How do I bring up the correct record ?

  • Thread starter Thread starter ArthurRW
  • Start date Start date
A

ArthurRW

I have a club database with over 225 records. I want to be able to open
individual records in "form" for updatinig by creating an index where
clicking on a name will open up the form with that individual's information
on it. If it requires a macro please go slowly, I've never done one before. I
already have my form, I just don't want to scroll through all those records.
 
I have a club database with over 225 records. I want to be able to open
individual records in "form" for updatinig by creating an index where
clicking on a name will open up the form with that individual's information
on it. If it requires a macro please go slowly, I've never done one before. I
already have my form, I just don't want to scroll through all those records.
Click to expand...

Add a Combo Box to your existing form (the form IS bound to the
members table, isn't it?)..
Place it in the Form's Form Header section.
Use the Combo Box Wizard when adding the combo box.
Select the 3rd option on the first page of questions, something like
"Find a record ...etc.
Follow the instructions.
When done, finding a members ID in the combo box will cause that
member's records to appear.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need an index for forms 2
How to stop records scrolling in bound form 2
Pop-up form that creates record that links 1:1 to main form 0
How to Partially Populate New Record 1
Records jumbled up! 5
Access Command to run access, open to specific form and specific record 1
how do I do this?? 1
Click on record, pop up form 1

Back
Top