Look up combo box?

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

Guest

I am making a form for owners of say properties. Luckily, I have an Intern
but to make sure she doesn't have to do more than necessary, I would like to
make a pull down combo box for her so if she pulls it down, finds an owners
that has been all ready been inputed, then she can pull up that owner, and
all the other field should be filled in so she can double check the address.
I think I know that I have to make a combo box, but I am hoping I can change
one thing and then everything will be filled in. Thanks in advance.
 
Add a header section to the form and in that section, add an unbound combo.
The wizard will walk you through the process. Choose the option that says
to find the record on the form. Your intern can use this combo to find
people and if they are found, the form will show their current record and if
they are not found, she can create a new record.
 
If I may...I'm having a bit of combo box trouble myself. I've used the
wizard in the manner described below, but I have found that in using the
next/previous arrows, the combo box selection does not update. I have tried
every which way to get the combo box to reflect the populated fields in
conjunction with the next/previous arrows to no avail in my new database (I
have had success in 2 others; this one is no different and I can't figure out
why it won't work). The combo box is my primary key.
 
I generally don't worry about the search combo but you need to be careful if
you try to change it in code. You don't want to put the form into an
endless loop.

In the form's current event put something like:
Code: 
If Me.cboSearch <> Me.MyPrimKey Then
Me.cboSearch = Me.MyPrimKey
End If
 
Back
Top