Form to Edit Table Data

[2524076]

I created a form1 to enter orders into a tableA.
My issue is I am trying to create a form2 that will allow me to edit the data entered in form1.
The edit form2 uses 2 combo boxes. Combo1 filters choices as to whether the order is "Quote", "Open" or "Closed". The second combo is based on results from Combo1 & selects the "Order#" and "CompanyName" and "JobDesc" in the RowSource for matching Records.
The Order# populates the combo2 no problem. My problem is how do I get CompanyName and JobDesc to populate 2 unbound text boxes on form2? Should I use unbound text or link the form to the tableA.
Ultimately I need to populate about 12 items on the form that can be edited.
Thanks for looking over my problem. I have used Access in the past but Form building is all new to me.

 

[IanAble]

It's not very clear from your description what you're trying to achieve with form2. If form2 is going to be used to display a filtered recordset using the combo1 and combo2 OnChange events of both controls to programatically filter the form recordset. In this case bind form2 to tableA. Adding records with defaults for CompanyName & JobDesc (based on what you've picked in thecombo boxes) is going to be more tricky.

Does this help?

 

[TheAceMan1]

How are ya 2524076 . . .

Have a look at [blue]DLookUp[/blue].

See Ya! . . . . . .

 

[2524076]

Thanks for the reply IanAble. You guessed correctly. I am trying to filter the recordset so I only look at OPEN files. I then want to select the correct job# and edit the table entries as such "shipped" or maybe edit an incorrect entry. I tried your solution and it works great, simple as it is. Thanks again.

 

[2524076]

Thanks for the reply AceMan1. I have yet to use the DLookUp function but will investigate. See Ya Back!