Form for editing records

[brocsman]

I posted a while ago about my problems with editing records, and I've got past those things. I've now got a query which is a subset of my data, filtered by date and location. The query works fine, and when I open it in datasheet view I can edit it, no problem.

My problem is developing a form to do the same. I want to open the form, based on the query, to edit one record at a time, in serial order. Say the name of the person who collected the data was wrong. I want to be able to see the name already in the dataset, but then I want to open a list of all the names on the Collectors table, and pick one to replace it, and store the replacement value in the underlying dataset when I navigate to the next record or close the form.

I keep trying to use combo boxes, but I just can't get them to work. This must be basic stuff, but I just can't see the wood for the trees. Help!

 

[DCrake]

Arre you using a bound control and setting the bound column correctly?

 

[brocsman]

Arre you using a bound control and setting the bound column correctly?

Sorry for the delay in replying - I've been away.

I think I'm using a bound control (shows how much I know). My main data table is normalised, so holds only keys to other tables. I want to display the existing record, eg the name, in text, (ie take the key from the data table and read the name value from the name table). Then select an alternative name from a list (which exists on the same table), then update the main record table with the key to the selected tuple in the name table. Does that make sense?

My underlying query allows me to do this, but when I try to use a form I get told I can't update because the item is bound. I don't understand this.