Re: Lookup in an Input Form
- From: pietlinden@xxxxxxxxxxx
- Date: 12 Oct 2006 09:15:54 -0700
Mike C wrote:
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).
.
- Prev by Date: cancel all but hex characters
- Next by Date: Re: Multiple criteria filter help
- Previous by thread: cancel all but hex characters
- Next by thread: Re: users quit from main app button but lose data
- Index(es):
Relevant Pages
|
