By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,299 Members | 1,225 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,299 IT Pros & Developers. It's quick & easy.

Auto Populate Forms

P: 2

I have a simple table that contains name, address, city, state etc.

I'm using a combo box to auto populate text boxes on a form I created which works ok....the only problem is that when I close the form it replaces the first record in my table with the record that was on the form.

Is there any way to stop this, I only want to display records in the table on the form not change or update them.(newbie)

Thanx in advance for any help

Joe Reid
Mar 2 '10 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 100+
P: 2,321
Set the AllowEdits value of the form to false. That will prevent edits from being made.
Mar 3 '10 #2

P: 2
Doesn't work now I cant make a selection from the combo box
Mar 3 '10 #3

P: 47
what your form is intended to, do you want to see registers on you table? do you want to add registers to ?
I usually tied the field no to table field but a query based on that table field,then I can set the AllowEdits combobx propertie to false and can pick a value from that combo and because the forms is based on a query I can populate the, related fields
Mar 3 '10 #4

Expert Mod 100+
P: 2,321
Make a unbound combobox on your field, with same Rowsource as your original combobox. Then add code in the AfterUpdate event of that combobox, to go to the specified record.
Mar 3 '10 #5

Post your reply

Sign in to post your reply or Sign up for a free account.