Write Clientnumber, the rest is looked up

[fluidmind]

Hello there!

I would like to create a form where a clientnumber is entered in a textbox1, and when the value has been entered, the name, adress and other info about the client will appear...

I really need to get this one right.

Thank you in advance

JR

 

[adjones1980]

It depends if the form you are in needs to be bound to the Client data or not. You'll need to write a bit of code in the AfterUpdate event of an Unbound textbox/dropdown in which you'll type the client number.

If the form is to be bound and entering a number jumps to the client record you want then in the code create a recordset clone of the form recordset, move through it until you have found the record with a matching clientnumber get the Bookmark of that record and set the form's bookmark to the same.

If the form is unbound the you will need do as above but open the correct table/query holding the client data as a recordset. You will then need to find the right record by moving through the recordset and then explicitly give the correct text/dropdown/list/checkbox etc the right value.