Quick VBA ?: How do you change record sources 1

[BotCow]

I have this form to fill out page descriptions of each notebook. I want to have one form for the 30 or so notebooks and so what I want to do is make a drop down menu to change the record source. How would I go about that using VBA?

 

[BillPower]

In the AfterUpdate event of your combo:

Docmd.Echo False
Me.Recordsource = Me!ComboName
Docmd.Echo True

If you have a sub form, maybe take a look at this site:

http://www.mvps.org/access/forms/frm0031.htm

Bill

 

[scriverb]

BillPower: Welcome back. Hopefully, the break has refreshed you.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[BillPower]

Hi Bob, Thanks, Yes and say no more.

Cheers

Bill