Question Edit in AutoNumber

[snirben]

Hi Guys,
i have build a table with autonumber.
how can i create a form to edit the fields in the autonumber,(not the number in the autofield),
when i typr the autonumber it will show me the fields that related and give me in options to edit them and save.
again i dont want to change the autonumber vaule.
thank you for your help, like allways.

 

[bob fitz]

Create a form which is bound your table.
Use the wizard to create a combo box on the form. Select "Find a record on my form based on the value I selected in my combo box" during its creation.

 

[snirben]

Create a form which is bound your table.
Use the wizard to create a combo box on the form. Select "Find a record on my form based on the value I selected in my combo box" during its creation.

its possible to do that if i type the vaule of the autonumber?

 

[bob fitz]

Yes if you have it in the list

 

[snirben]

Yes if you have it in the list

thank you, last question there is a way to make a button near the combobox that will open a popup windows with a table that i can filter and choose one of the autonumber and then it will open the autonumber in the first form?

 

[The_Doc_Man]

Look up the topic of "Cascading Combo Boxes" in this forum. It is CERTAINLY within the realm of possibility to define a filter with one combo box and use that to affect the .RowSource query that selects your record via the Autonumber. The only trick will be to force the combo box to requery after you update the filter box - which would occur in the OnChange event for the first box.