Code difference for single form versus continuous form

  • Thread starter Thread starter Fox
  • Start date Start date
F

Fox

Is the code different for a form that is default view single form and a form
that is default view continuous form....
i.e. this code:
WHERE (((unitpriceqry.JeweryComponent)=[Forms]![New My Beading Project
frm]![NewAddComponentSub].[Form]![AddComponent]));

The line of code above works find on the form if it is a single view but
when I make the form a continuous form it seems to be treating each line as
the same record...
any help would be apprieciated.

Thanks,
 
Is the code different for a form that is default view single form and a form
that is default view continuous form....
i.e. this code:
WHERE (((unitpriceqry.JeweryComponent)=[Forms]![New My Beading Project
frm]![NewAddComponentSub].[Form]![AddComponent]));

The line of code above works find on the form if it is a single view but
when I make the form a continuous form it seems to be treating each line as
the same record...
any help would be apprieciated.

Thanks,
Click to expand...

What result do you expect? Referring to the name of a control on a form
(continuous or single, or even datasheet) will refer to a single value - that
control on the currently active (selected) record.
 
hm...
I see that it accually didn't work on the single form ...just not as
noticeable...
When I change the combo the price field updates but it is updating the
combo's for all records with the same data....
--
Foxy


John W. Vinson said:
Is the code different for a form that is default view single form and a form
that is default view continuous form....
i.e. this code:
WHERE (((unitpriceqry.JeweryComponent)=[Forms]![New My Beading Project
frm]![NewAddComponentSub].[Form]![AddComponent]));

The line of code above works find on the form if it is a single view but
when I make the form a continuous form it seems to be treating each line as
the same record...
any help would be apprieciated.

Thanks,
Click to expand...

What result do you expect? Referring to the name of a control on a form
(continuous or single, or even datasheet) will refer to a single value - that
control on the currently active (selected) record.
Click to expand...
 
hm...
I see that it accually didn't work on the single form ...just not as
noticeable...
When I change the combo the price field updates but it is updating the
combo's for all records with the same data....
--
Click to expand...

I'm not visualizing what you're doing. Is this an Unbound combo box or
textbox? If so it's not updating anything, it's just displaying the same value
in all records on the form; the data exists only on the screen and isn't
stored anywhere.
 
Back
Top