Lookup in an Input Form

[Mike C]

I have a form that I input data into and it is great. I have various queries
and reports that I'm able to generate based on the data I've entered.
However, going back into the form (or table) to modify the data is starting
to become a major chore because over time a lot of data has accumulated and
it is tedious to find the record that I have to modify.

I've created a combo box on my form with a recordsource of all the ReqIDs in
the table. I'd like to select one of those ReqIDs in my combo box and have
the input form go to that recordsource.

Any ideas or suggestions would be greatly appreciated, thanks in advance.

cbo_ReqLookup
frm_ReqInput
tbl_ReqInput

 

[pietlinden]

I have a form that I input data into and it is great. I have various queries
and reports that I'm able to generate based on the data I've entered.
However, going back into the form (or table) to modify the data is starting
to become a major chore because over time a lot of data has accumulated and
it is tedious to find the record that I have to modify.

I've created a combo box on my form with a recordsource of all the ReqIDs in
the table. I'd like to select one of those ReqIDs in my combo box and have
the input form go to that recordsource.

Any ideas or suggestions would be greatly appreciated, thanks in advance.

cbo_ReqLookup
frm_ReqInput
tbl_ReqInput

Which version of Access are you using? If you turn the wizards on, you
should be able to drop a combobox on your form and the wizard should
ask what your combobox will do. Choose "go to selected record" (can't
remember the exact wording).