Editing with Combo Boxes

L

Lovespar

I am trying to use a form to edit information in a table. I have an unbound
field to search for records by, working fine. But when I tried to put in some
combo boxes so that editing fields would be easier, the data in those fields
did not change when I changed the records. I must not have something right.
Some of the fields will be filled in, but some of them will not depending on
the record so I want the record to reflect what has already been entered.
thanks in advance
 
A

Armen Stein

But when I tried to put in some
combo boxes so that editing fields would be easier, the data in those fields
did not change when I changed the records. I must not have something right.
Some of the fields will be filled in, but some of them will not depending on
the record so I want the record to reflect what has already been entered.
Click to expand...

Open the properties for the combobox. On the Data tab, look at the
ControlSource property. It should be set to a fieldname from your
form's recordset. Yours sound like they are unbound, meaning that the
data is just on the form and isn't attached to the underlying records.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
L

Lovespar

Armen Stein said:
Open the properties for the combobox. On the Data tab, look at the
ControlSource property. It should be set to a fieldname from your
form's recordset. Yours sound like they are unbound, meaning that the
data is just on the form and isn't attached to the underlying records.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

Thanks, it works now!
Click to expand...
 
D

De Jager

Lovespar said:
I am trying to use a form to edit information in a table. I have an unbound
field to search for records by, working fine. But when I tried to put in
some
combo boxes so that editing fields would be easier, the data in those
fields
did not change when I changed the records. I must not have something
right.
Some of the fields will be filled in, but some of them will not depending
on
the record so I want the record to reflect what has already been entered.
thanks in advance
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Split form 0
Creating a Search using a combo box and then creating a report. 4
Dynamic Naming of Form Button 3
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
Cannot do anything after zooming - Publisher Lite on Mac 0
Optionbutton Not working 3

Top