using a combo box to check data

[Holmes]

Hello (Again!)

I have a form that is mainly used for data entry (for call logging). Ideally it will be linked to 4 different tables, however I need to get the basics working.

My new problem is being able to look up data that is selected in a combo box to see if it is out of date. I shall clarify, as stated the form is for call loggin, when someone calls I ask for their postcode, this is in the combo box.
I want to then use the postcode selected to data from another table that lists services due, and if the service is due for that postcode within two weeks highlight the text box in red.

Any ideas?

(access newbie so please bear with me!)

Many thanks.

B.

 

[neileg]

I would:
Base the combo on a query that retrieves the postcodes that relate to your customers plus the customer ID field in a second column.
The native behaviour of a combo is that as you type into the box, it 'zooms' to the data value you are typing.
Have a command button that opens a form that uses the customer ID as the criterion for its underlying query from the services table.

 

[Holmes]

Many thanks will use something along those lines.