Why is my drop down selection changing records?

[Perissos]

ooooooooh ok.

I have a form with three combo boxes on it. The first one is based on a query which selects the distinct name from the table, the other two I have as a list.

I originally tried to make this unbound because I thought that would be the best way, but in trying tons of stuff, I decided to change that. So I have a query which pulls distinct records and then use the information gathered from the combobox to gather the data for the subform.

It works great except for one problem. I can not edit the records in the subform. It just beeps and down in the lower left hand side of the screen it says "This recordset is not updateable"

What can I give you that will help me solve this? I have tried making the form several different ways and the only time I didn't get the error it turned out that it was actually changing the records to be assigned to the new selected name.

[nico5038]

You need to record in the subform's table the target table for your comboboxes. (They are in fact "Foreign keys") Then Access will by default make a combobox when placing the field on the form.

You now have trouble as Access doesn't allow a JOINed query to be updatable.

Nic;o)

[Perissos]

I decided to redo the form one step at a time to see where the problem was. I took the combo boxes out and put the subform to a query based on a static selection. I put the subform back into the main form, still and I can update it with no problem except my record selectors and navigation buttons don't appear... yes I check to make sure the record selector option was set to yes...

If I can get that fixed, even though I don't think I should have to do it this way... I will re-create the query when the get data button is selected and requery and repaint the form.

If anyone has a better suggestion I am open to ideas

[Perissos]

they are actually fields in the same table and if you mean the master/child links.. I tried that

[nico5038]

Hmm, losing me with "they are actually fields in the same table"

Normally a combo is based on a linked table or a value list.

Just make sure your subform is based on a table and not on a query with a JOIN.

Nic;o)