Combo Box Problems 1

[mrblonde]

Hi,
I need simplistic, hold my hand, style instructions. I have a Query Named Attributes. The Primary Key involved is Job_Number. Using a wizard I have created a form. I would like to change the Job Number Text Box to a Combo Box. What I want to do is have a user click a value in the list, and have the rest of the fields follow suit, so they can be edited. I've been stuck for two days so any help is a flippin' blessing.

Thanks...

 

[JerryDennison]

Use a form(you can base it on this query if you'd like). Set the form up like you would any other form. In the header add an unbound combobox. The combobox wizard will walk you through setting it up to find records based on the selection. Use the PK for this combobox to search on and you're done.

 

[mrblonde]

I created the form based off of a query. And it works great. However, I also would like to update records. So, I used the wizard to create the form and then added a combobox after the fact and I get a syntax error. Is there a way to search using a combobox on the primary key, and be able to change values in the records that appear?

 

[JerryDennison]

Yes. Make sure the form is bound to an updateable recordset that is tied to the table you wish to work with. Then use the method I described above for finding a record. If the controls are bound to the fields of the recordset any changes made are to that record.