P
pattlee
I have a combo box on a form (Categories) that allows the user to select a
Category and a table on the form that displays all items under that Category.
The user then "checks" the line item, enters some data, and then goes back to
combo box to select another Category, looks at the line items, "Checks" some
items... etc There may be up to 10 line items checked under five different
Categories. Am sending the checked line items via command button to a report
and this is going well... The Problem: I need ONE unique number to be
assigned to all the checked records prior to reaching the report.. How and/or
where do I create/assign this number? Hope this is clear.. Not a VBA person
and Access newbie... Would really appreciate some help... Regards Patricia
Category and a table on the form that displays all items under that Category.
The user then "checks" the line item, enters some data, and then goes back to
combo box to select another Category, looks at the line items, "Checks" some
items... etc There may be up to 10 line items checked under five different
Categories. Am sending the checked line items via command button to a report
and this is going well... The Problem: I need ONE unique number to be
assigned to all the checked records prior to reaching the report.. How and/or
where do I create/assign this number? Hope this is clear.. Not a VBA person
and Access newbie... Would really appreciate some help... Regards Patricia