ORder Form Help

tkd1987

Registered User.
Local time
Today, 15:30
Joined
Jan 3, 2006
Messages
26
Hello,
i am really struggling in access creating an order form and an invoice report.

the attached example shows what i have so far.

however for the order form what i would like to do is have a drop down menu at the top which will have a list of invoice reference number for that particular student. which will in in the format of surname/date eg Bannister11/01/2006

as people will be ordering things at different times and need a new invoice each time. i see this as the easiest way. could any body help me with this??

Help is much appreciated

Aaron
 

Attachments

  • sales copy.jpg
    sales copy.jpg
    75.7 KB · Views: 118
Last edited:
is the drop down menu to see old orders. If it is make the combo box an unbound field and use an sql statement as a filter for the form.

Ash
 
cool that is exactly what i want but how do i do it?
 

Users who are viewing this thread

Back
Top Bottom