Find Record on Another Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If a combo box can be used to jump to a record on my open form and a button
wizard can make a button to open Form2 to match criteria selected on Form1,...

how do I create a button (located on Form1) which will open all the records
on Form2 but will jump to the first match of the criteria selected in form1?
 
Beverly76 said:
If a combo box can be used to jump to a record on my open form and a
button wizard can make a button to open Form2 to match criteria
selected on Form1,...

how do I create a button (located on Form1) which will open all the
records on Form2 but will jump to the first match of the criteria
selected in form1?
Click to expand...

Include the search criteria string as the OpenArgs argument and then use the
second form's Load event to execute the search using the OpenArgs string.
 
I sort of understand the words in context, but I'm not sure how to do it.

Also, is there a book I should get to help me figure out how to use code in
Access. I bought a book on VB.net which is way over my head and doesn't seem
to apply.
 
Beverly76 said:
I sort of understand the words in context, but I'm not sure how to do
it.

Also, is there a book I should get to help me figure out how to use
code in Access. I bought a book on VB.net which is way over my head
and doesn't seem to apply.
Click to expand...

Examine the code behind your ComboBox that jumps to a specifc record. You just
need to duplicate that in your second form only use the OpenArgs string as the
"supplier" of the search instead of the value from the ComboBox.
 
Back
Top