Combo Box help (database included) (1 Viewer)

[andrew.bistak]

hi All,
I've included an extremely cut down version of my database (33k zip file) with the example I'm trying to do.

There is a Combo Box (three options), I basically want this box to switch to the relevent record. (e.g. if you select Rural, it will switch to the next rural record) Rather, the combo box is changing the field of the current record to Rural which I don't want it do. I also want the ability to "Filter by Selection" too which it does but it just changes the current record

Any help would be GREATLY appreciated! It's been driving me crazy for days now.

If you click on "FOCUS OF SERVICE", the combo box in question is called "AREA" that is located up the top.

databasedemo.zip

thanks,
andrew

 

[trucktime]

Combo Box

It doesn't work because the necessary code in the After Update Event
of the Combo Box is missing.

Check out this link:
http://allenbrowne.com/ser-03.html

Or search this forum, there are many good examples around

 

[andrew.bistak]

Thanks Trucktime, I'm unfortunately new to the game of MS ACCESS but I'm slowly getting there.

With that demo code, what exactly does this line mean?

Dim rs As DAO.Recordset

regards,
Andrew

 

[andrew.bistak]

Do I need to use forms for this?