Getting started

  • Thread starter Thread starter grapejuice
  • Start date Start date
G

grapejuice

I am starting a Form for Users to look up information based on tw
search criteria of Firstname and Lastname.

Next, based on a match, I need the form to be re-populated to reflec
the addtional information based on the match.

If multiple matches are found, I was thinking about having a spi
button activate and rotate to the next record within the search.

Any pointers in the right direction, as far as what VB options I nee
to research for my database, would be greatly appreciated
 
grapejuice,

What you want to do, can be done but you'll need to break
your questions into smaller chunks and I'm sure that the folks
in the ng would be happy to help you out.

I'll try to get you started though............

Here's one way to accomplish what you want:
(Assuming that you have your data laid out with one record to a row)
Via code...Autofilter your data list and then sort it by last name
Populate one ComboBox on the UserForm with just the last names.
(Actually better would be a two column ComboBox with Last and
First Names).
Upon selection from the first ComboBox, filter your data and then
populate the second ComboBox (if used) with what's left on your
filtered list.
Upon selection of the second ComboBox, filter your list again
on the values from ComboBox1 and ComboBox2.
If there aren't any duplicates in your filtered list, you should now
only have one row visible.
Using the SpecialCells.Visible, you should be able to populate
the rest of the fields on your UserForm.

There are other ways to do this.
This is just to give you some ideas.

John
 
Hey people....

I was following this Thread....and I have to say that I would like to
know how this ended.

could you place your final script or send it to me?

Thank You for your help!

Dingetje (NL)
 
Hey people....

I was following this Thread....and I have to say that I would like to
know how this ended.

could you place your final script or send it to me?
 
Well, I am still working on the VB for the form. I choose not to use
the combo box feature because my form is for inquiry and input to save
time and confusion of users. I am looking into the Find command but I
need to work out the kinks of matching based on two fields. Once I am
done, I will pass on anything helpful...
 
Back
Top