Combo box to change tables Record

[ramasule]

I'm posting under a different title because my last title was confusing.
What I am really trying to ask is there a way to use a combo box on a form to move through the forms "records".

I have a form that updates a table called permits.
I wish to use a combo box on that form to select which permit I edit.
Currently when I do this it tries to update the just the permit ID under the Record ID.

Is this possible or do I have to make another form to access the Permit ID.

Your time is appriciated thank you,

Derek L

 

[melanie]

Derek is your form bound to the table? Are looking for a combobox to find the matching record on your form so that you can edit that record?

 

[melanie]

If it is bound then click the combobox control on the toolbox in form design. As you drag it onto your form a message box will appear giving you three choices:

1. Look up values in a table
2. Type in the values that you want
3. find a record on your form based on the value you select in the combo

It will be no. 3 you're after. On the next message box select the field you want the combo to find i.e. permitid. Click next next finished.

Is the permitid you want to change an autonumber?

Regards
Melanie

 

[ramasule]

Thank you Mel.

Option number 3 is what I needed.

Your help was greatly appriciated.

On another note is there a way to quickly generate a table
that has the PermitID (primary Key) go from say 0-1000 with blanks in the other fields?

Or advise on where to put my Do While loop .

Thanks,

Derek L

 

[melanie]

Derek

Glad to have been a help.

Post your new question back to the forum.

Regards Melanie