Continuous forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Not quite sure what you mean by a join in the query.

the subform is based on a single table
 
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
 
Back
Top