combo box

[He cries for help]

I have a form that I added a combox to, the combo box gathers its information
from a table called "two", the form fields info is entered into table "one".
I have used the control source of the field properties with the code
"=[combo16].column(1) to fill certain fields. The issue is every time I
select from the combo box it changes all the previous records to the same
thing. Lets hope this is an easy fix.

I am using Access 2003..

 

[Allan Murphy]

This will happen if the you are using a continuous form and storing data to
an unbound field.

Allan

 

[He cries for help]

How do I remedy the situation??

This will happen if the you are using a continuous form and storing data to
an unbound field.

Allan

I have a form that I added a combox to, the combo box gathers its
information
from a table called "two", the form fields info is entered into table
"one".
I have used the control source of the field properties with the code
"=[combo16].column(1) to fill certain fields. The issue is every time I
select from the combo box it changes all the previous records to the same
thing. Lets hope this is an easy fix.

I am using Access 2003..

 

[John W. Vinson/MVP]

I have a form that I added a combox to, the combo box gathers its information
from a table called "two", the form fields info is entered into table "one".
I have used the control source of the field properties with the code
"=[combo16].column(1) to fill certain fields. The issue is every time I
select from the combo box it changes all the previous records to the same
thing. Lets hope this is an easy fix.

I am using Access 2003..

A Continuous form *appears* to have many rows of controls. However, in
a sense it really doesn't: it has *one* row of controls, displayed
many times. If you change the properties of one control (such as its
control source), the change is displayed on all the instances of the
control. The only exception is if you bind the control to a field in
the Form's Recordsource query.

You may need to change the Recordsource, either to base it on a query
joining [one] to [two], or putting a calculated field in a vacant
Field cell such as

=DLookUp("[fieldname]", "[two]", "[idfield] = " & [idfield])

to display the looked-up value.