Make textbox mulually exclusive on continuous form

[Guest]

I have a form with the record source being a query. To do a test this I have placed some sample data ina table returned this to the forms detail (n.b. I have set the default view to continuous). 3 records are returned which is what should happen.

I want to add a text box for each record returned so the user can input. I have done this by adding a text box to the forms detail, beside the query result.
When I add a value to a text box it populates that value into all the text boxes for the records returned. I think this means it has created multiple instances of the one object.

How do I make them independant?

Here is some sample data as an expample, if I fill in textbox1 them same value appears in textbox2.

Record 1 Value1 textbox1
Record2 value2 textbox2

Bruce

 

[tina]

when you look at a continuous form, you're seeing multiple records, but
there is only one of each control on the form. a look in the form's design
view will confirm this for you.
do you want the user to be able to enter data in a record, and have that
data saved to the record in the underlying table? if so, you need to first
make sure there is a field in the underlying table to hold the data. then
make sure the field is included in the form's RecordSource - in this case,
the query. then add a control to the form to enter the data - which you say
you already did. last, enter the field name (from the query) in the
control's ControlSource property.

hth

I have a form with the record source being a query. To do a test this I

have placed some sample data ina table returned this to the forms detail
(n.b. I have set the default view to continuous). 3 records are returned
which is what should happen.

I want to add a text box for each record returned so the user can input. I

have done this by adding a text box to the forms detail, beside the query
result.

When I add a value to a text box it populates that value into all the text

boxes for the records returned. I think this means it has created multiple
instances of the one object.

 

[Guest]

Thanks Tina
Understand what your and you have also interpreted my question well
The problem with you solution is that the field that needs updating is on the many side of the relationship

Essentually its a sales promotional deal by product by customer
The recordset is basically a pricing table which are the records I am returning. The text field is the promotional price I want to add and is accompanied by a start and end date. This is important as a cusotmer can have multiple deals for the saem product. The term of the deal makes it unique
In this way Im lost thow to approach the problem with your suggestion as it assume a 1:1 relationship

I figured I could basically set the form up through lookups and create an append query once the data is arranged. This would work except for the control problem I have

Am I approaching this the wrong way.

Bruc

 

[tina]

the solution i suggested had nothing to do with relationships, really, so i
have a feeling we're not quite communicating too well, but...
if you have 2 tables with a one-to-many relationship that is *set up in the
Relationships window*, then the easiest way to set up a data entry form is
to
1. in the database window, go to the Tables tab.
2. click on the "one-side" table (parent table), to select it, but don't
open it.
3. on the the toolbar, click on the AutoForm button.
Access will create a form for the parent table as Single record view, with a
linked subform for the "many-side" table (child table) as - probably - a
Datasheet view. that should make your data entry easy.

hth

Thanks Tina,
Understand what your and you have also interpreted my question well.
The problem with you solution is that the field that needs updating is on

the many side of the relationship.

Essentually its a sales promotional deal by product by customer.
The recordset is basically a pricing table which are the records I am

returning. The text field is the promotional price I want to add and is
accompanied by a start and end date. This is important as a cusotmer can
have multiple deals for the saem product. The term of the deal makes it
unique.

In this way Im lost thow to approach the problem with your suggestion as it assume a 1:1 relationship.

I figured I could basically set the form up through lookups and create an

append query once the data is arranged. This would work except for the
control problem I have.

 

[Guest]

Thanks Tina

Will give it a go...

Bruce