General :: Using A Combobox To Select Records To Edit On A Form?

I am creating a data base to handle access requests to a building. All has gone well so far and ive built tables, reports, forms and used queries. However now im trying to get abit more clever and ive hit a bump of understanding/apprach.

Whilst a ninja in Excel, im still working out which is the pointy end in Access.

The database holds all details of access requests inc: Company attending, Individual attending, Access Levels and Period of attendance. This is all done with forms for the users and functions beautifully (ish).

I can run reports on this data, based on queries (there is much more included than above but you get the idea) and generate all the reports I need.

What I wanted to do was add, following attendance to the site, the card details of the AC card they were given for the visit.

My intention was to have a form with three variables: a combobox that would let you select the individuals company and two text boxes to select a date range in. Leaving just say three or four people from that company on that day rather than everyone who had ever atteneded to sort through and add the card details.

The combo box comes from another query that gave me individual company names from the main table.

I thought a date query (as in placing a more than <> or less than criteria vs textbox value on form in the query build section) could be added but I hadnt got that far.

It seems what I have done works backwards (oops), I can adjust the query from the form but get every record in the table on the form to click through to add card details, which will be abit rubbish when i have 1000's of requests building up in the history.