Auto populate records

razorking

Registered User.
Local time
Today, 01:55
Joined
Aug 27, 2004
Messages
332
Hope I can word this in a way that makes sense: I have created a form that is to be used to calculate and convert square meters to inches. So we have material - slabs - and when we receive these we have packing lists that come in M2 (square meter) and we need to convert to inches. There is a length and a width for the material, the user enters length and width - in M2 - and the conversion is automatic to inches.

What I am wondering is:since we pretty much always have multiple entries I need the user to "open" up multiple lines (records) on the form. So if block 1 has 20 slabs and block 2 has 10 they have to begin that many records - if that makes sense.

Is there a way to just tell the form: I need to open 10 records for a and it will do that and then you just key in length and width?

see attached
 

Attachments

  • accessform.jpg
    accessform.jpg
    91.5 KB · Views: 99
You want the user to be able to select a certain number of records that should be displayed or returned?

Look into the sql TOP predicate.
 

Users who are viewing this thread

Back
Top Bottom