G
Guest
Hello.
My Dilema:
I have 2 tables. One of which is of mostly static records that may get
updated every so often. The other is of 5 columns that the user must update
everytime she prints labels, via a report.
The first table has a style number for the first column. There can be
repeats here as there may be multiple records for each style. The rest of
the columns here are just for printing the label and have no impact on the
query portion, just the final label report.
When running the report, I need to :
1). Ask the user what style (from the first table) they want, and list the
"List Form showing the style records, for verification purposes. (For
example if I want to print style 805, I can enter that in and push that data
to the final report)
2). After verification the user must press ok, to goto the form for the 2nd
table, or in the same form, enter in # 3 below:
3). Ask the user for the 5 columns of data in the 2nd Table, preferably by a
form.
4). Data from both the 1st and 2nd table must be in the final address label
report.
I can do the conditional query and make a report based on that information.
The main problem I am having is getting a form to get the 2nd tables input
from the user (in turn updating that table), and getting the result of the
Style query and the user input to be used for the report.
Note: the 2nd table will only have one record, as it will change every time
the report is printed.
Thank you in advance. Im so lost =) been reading the Microsoft sites for 2
days working on this.
My Dilema:
I have 2 tables. One of which is of mostly static records that may get
updated every so often. The other is of 5 columns that the user must update
everytime she prints labels, via a report.
The first table has a style number for the first column. There can be
repeats here as there may be multiple records for each style. The rest of
the columns here are just for printing the label and have no impact on the
query portion, just the final label report.
When running the report, I need to :
1). Ask the user what style (from the first table) they want, and list the
"List Form showing the style records, for verification purposes. (For
example if I want to print style 805, I can enter that in and push that data
to the final report)
2). After verification the user must press ok, to goto the form for the 2nd
table, or in the same form, enter in # 3 below:
3). Ask the user for the 5 columns of data in the 2nd Table, preferably by a
form.
4). Data from both the 1st and 2nd table must be in the final address label
report.
I can do the conditional query and make a report based on that information.
The main problem I am having is getting a form to get the 2nd tables input
from the user (in turn updating that table), and getting the result of the
Style query and the user input to be used for the report.
Note: the 2nd table will only have one record, as it will change every time
the report is printed.
Thank you in advance. Im so lost =) been reading the Microsoft sites for 2
days working on this.