Forms based on Query & Data Entry

G

Gage

Using a form based on an Access 2002 database to create labels. Prompt
for 2 things, one is a part number, other is a serial number.

Part number does a search, and comes back with description and othe
information, and the Serial Number is pasted onto the label.

What I need to figure out how to do is allow me to enter in multipl
serial numbers into an array, and have it generate a form for each one
all using the same Part Number entered, so they each show as a separat
page in the Print Preview Form which comes up.

I know VBScript (at least I used to, been a while since I worked wit
it) but can't seem to figure out how to hardcode prompts and return
like this, since the prompts appear to be done automatically by th
varius Text boxes on the forms. The code section of the form itsel
appears pretty much blank.

Note: This is an already existing and functional form, I need to modif
it
 
T

TC

Sorry, I think your question is too unclear for people to answer.

You have a form. The form requires you to enter a part number. When you
do enter a part number, the form replies with the part description &
other relevant information. So far, so good!

Then you enter a serial number. Exactly what does happen then? Exactly
what would you like to happen instead?

TC
 
T

TC

PS. And where does VBScript come in to this? The programming language
for Access is "Visual Basic for Applications" - VBA. VBA is similar to
VBScript, but not identical.

HTH,
TC
 
G

Gage

Sorry guys, after I posted this I realized that I had mistaken Forms an
Reports in my head, and posted this in the wrong forum. That's why
edited the first post to ask it to delete it, since I couldn't find th
option to delete it myself
 
Top