Find box on a form

[carolinera]

On my form I have a find box which the user types in the last name of the member. This in turns brings up the information for this member. I have since added a few new names but their last names are not showing up on the find function. This "find" is connected to "tblmember". These individuals are on the table but not on the list in the find function. Help please!!!!

 

[Jack Cowley]

In your form add a Combo box using the Wizard. On the first screen select the 3rd item, "Find a record...". Finish the rest of the Wizard. Now you can start typing in the name you are looking for and the Combo box will start filling it in for you. When it finds the name and you hit enter the form will be filled with the record found in the Combo box.

[This message has been edited by Jack Cowley (edited 10-25-2001).]

 

[carolinera]

Thank you Jack....but I have already got that part. My dilemma is that once I add a member, the find box doesn't have the name on the list in the combo box therefore I have now got duplicates in my database. How do I get the list to update? The names are already on the table named "tblmember".

Thx

 

[Jack Cowley]

Do you mean that the names that you have added have never shown up or the just don't show up until you leave the form and come back to it? If the latter than you need to put a Me.Requery or Me.Refresh somewhere in your code to refresh the combo box. If you have added names to the table and they are not showing up at all then there is something wrong with how you have the combo box set up.