Creating a subform for input to a table

[MacMan]

I need to be able to create a form that a clerk can enter a new sale ticket number into and then in the subform list the items being sold. The table record would contain the following fields.


TicketNumber
Consignor
Unit Price
and could include the Unit Total (Can be calculated at time of entry or when generating reports.

Later a couple of reports will be generated (Already built) That can validate the ticket by ticket. Provide a report by Consignor for all of the items sold by that consignor and a Total sales report that would show all consignors, their totals, the commission and the final check total.

I have built a form with this information but it shows all of the data already in the table . How do I set the form up so it is just for data entry?

I have a system set up so I can provide it if you need to see what I am talking about here. It is 1.5 Meg so I can't include it with this post.

Thanks in advance for your help..

[June7]

2MB zip file can be attached to post. Use Windows Compression.

If form DataEntry property is set to Yes then the form will only allow new record entry. However, I prefer to set this condition when opening the form by a button click:

DoCmd.OpenForm "form name", , , , acFormAdd

This allows one form to serve multiple purposes. I could open it from a different button to view existing record(s):

DoCmd.OpenForm "form name", , , "ID=" & Me.tbxID

[MacMan]

June7 Thank you for your response.

CCE1.zipI tried the Data Entry mode but that didn't seem to work. File attached

[June7]

Don't understand data structure. How can a ticket have more than one consignor?

Need to set subform container control Master/Child Links properties.

You have autonumber ID field in Tickets set as primary key but you are saving TicketNo as foreign key in InputFile. Either set TicketNo as primary key or save the ID as foreign key.

[MacMan]

A ticket is a sales slip which will have multiple items that a client wants to buy. Each Item could have different Quantities will be from a consignor. For example I buy 3 different items but one of them I buy 2 of the same thing. So the ticket would have three items listed, 2 would be a quantity of 1 and 1 would have a quantity of 2.

I reset the Ticket Table Field Ticket to be the primary key, but in saving I get an error "Index or primary key cannot contain a Null Value. "

[orange]

Many readers are not familiar with your environment and do not understand how your business is set up. It would help readers and you, if you could give us a 5-6 line overview of the business you are in from the 30,000 foot level. It will improve communications for us all.
Also, you should review Primary and foreign keys.
Good luck with your project.