Continuous forms

I have a continuous form that i use to add partno`s for a price check. i use
dlookup to pull the description and other details into text boxes but wheni
add a second partno itchanges the description field a on all lines.

Is there a way to stop this or can someone tell me another way of adding
multiple order lines.

Thank in advance

When you assign a value to a control in a continuous form, it does so for all
records. Assuming your form is based on a query, move the DLookup function to
the field in the query. Better yet, do a join in the query to pull the
description.

Barry

"Gazza" wrote:

I have a continuous form that i use to add partno`s for a price check. i use
dlookup to pull the description and other details into text boxes but wheni
add a second partno itchanges the description field a on all lines.

Is there a way to stop this or can someone tell me another way of adding
multiple order lines.

Thank in advance

Not quite sure what you mean by a join in the query.

the subform is based on a single table

"Barry Gilbert" wrote:

When you assign a value to a control in a continuous form, it does so for all
records. Assuming your form is based on a query, move the DLookup function to
the field in the query. Better yet, do a join in the query to pull the
description.

Barry

"Gazza" wrote:

I have a continuous form that i use to add partno`s for a price check. i use
dlookup to pull the description and other details into text boxes but wheni
add a second partno itchanges the description field a on all lines.

Is there a way to stop this or can someone tell me another way of adding
multiple order lines.

Thank in advance

You should create a query based on the table. Then add the table that
contains the descriptions. You then join the two tables via the partno field.

Look in Access help about queries and joins for more help on this. It would
take too much to explain it in a newsgroup.

Barry

"Gazza" wrote:

Not quite sure what you mean by a join in the query.

the subform is based on a single table

"Barry Gilbert" wrote:

When you assign a value to a control in a continuous form, it does so for all
records. Assuming your form is based on a query, move the DLookup function to
the field in the query. Better yet, do a join in the query to pull the
description.

Barry

"Gazza" wrote:

I have a continuous form that i use to add partno`s for a price check. i use
dlookup to pull the description and other details into text boxes but wheni
add a second partno itchanges the description field a on all lines.

Is there a way to stop this or can someone tell me another way of adding
multiple order lines.

Thank in advance