Combo box to change tables Record

ramasule

Registered User.
Local time
Yesterday, 22:50
Joined
Mar 13, 2007
Messages
33
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
 
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?
 
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
 
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
 
Derek

Glad to have been a help.

Post your new question back to the forum.

Regards Melanie
 

Users who are viewing this thread

Back
Top Bottom