Create a list to be used as criteria

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

Guest

I am trying to design a form that will be used for the criteria of a query.
What I want the form to do is create a list of files and have those files be
the criteria.

The query has the fields: FilePre, FileNum, FoldNum

In the form I want the user to be able to specify all three field and add
them to a list, up to 30 entries, to then be used as the criteria for the
query only returning the records that match.

Thanks for any help you can provide.
 
If the data gets stored into a table, then you should be able to link that
table to whatever other table. The inner join should do the rest. Unless
there's something you're not telling.
 
The data is stored in two different tables with a link. The purpose is to
create file folder labels. One table contains all of the prefixes the other
just contains two fields of numbers, 1 thru 20,000. The use currently has the
ability to specify one prefix and a range of number to create the labels. For
example:

Prefix Number Start Number End
A 1 30

This returns the sheet of labels containing A1, A2, A3…A30.

I want to give the user the ability to specify exactly what labels they want
for example:

Prefix Number Folder
A 21

A 26 6
B 119 1
B 119 2
F 982
G 716 1

I want this to return A21, A26 6, B119 1…G716 1.

I hope this is clearer.
 
I suppose that the form has a subform, of which the user can enter all of
their desired label values.
I'll also assume that the subform is based on a table, which is where the
data is stored?
The table is then used as the basis of the report??
In the report, you could concatenate the needed fields to print the label???

Where do my assumptions go astray????
 
The form does not contain a subform currently but adding one would not be an
issue. It is a very basic form with unbound controls that the query pulls
from and uses for criteria. The report is then generated from the query. The
thing is I do not want the lists that are created saved. Each list is unique
to the user that time only and will most likely never be required exactly as
it was the first time.

Thank you for helping with this.
 
The table could be emptied when the form opens and/or closes. The table
provides simplicity in that you have multiple entries needed for the
completion of the label printing. Just a temp holding bin long enough to
get the labels out, then you can purge the data.

It should be real straightforward if you do it this way, I think.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting
 
Thanks, worked like a charm!

[MVP] S.Clark said:
The table could be emptied when the form opens and/or closes. The table
provides simplicity in that you have multiple entries needed for the
completion of the label printing. Just a temp holding bin long enough to
get the labels out, then you can purge the data.

It should be real straightforward if you do it this way, I think.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting
Click to expand...
 
Back
Top