Go to record by entering Invoice value (1 Viewer)

[Leonhuynh]

Dear all,

I have a set of record of Invoice: IV001, IV003, IV00A,etc. I would like to design a textbox in the Invoice form, when I enter the invoice value, I will go to that Invoice and enable me to edit. Please help me with vba code

Thanks all

 

[CJ_London]

you'll need to explain your setup

do you have the standard 'invoice header' and 'invoice line' tables? if not, what?

how is your form structured? Main form with subform? single form? If so, what are the recordsources for each form?

At the moment, best I can suggest is any vba code would go behind the textbox after update event or perhaps a click event of a button.

are you wanting to 'find' a record on a continuous form? or 'filter' to display just the one record?

 

[HiTechCoach]

TIP: Use the control wizard for a combo box.

Adding a combo box with the control wizard in the form header and will do exactly what you want. And it will write all the require code!

By using a combo box it will also validate the data and make it easier to find. I have found users like it much better than a text box.