Auto Populate Forms

[noboat1]

Hello,

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

[TheSmileyCoder]

Set the AllowEdits value of the form to false. That will prevent edits from being made.

[noboat1]

Set the AllowEdits value of the form to false. That will prevent edits from being made.

Doesn't work now I cant make a selection from the combo box

[rwalle]

Noboat1:
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

[TheSmileyCoder]

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.