Help!!!

[daneo2k3]

Im so stuck! i have a form based on a table for a purchase order, as you can see on the attachment, i have certain boxes on the form header and footer for example the purchase order number because it is only used for that purchase order the problem i have is i need the the form design to be able to come up but with no fields filled in only the purchase order number which i need to be an auto number but it cant be a field because i dont need a purchase order number for each individual item confusing i no but hopefully the attachment will help? any advice much apprieciatted dane

 

[Mile-O]

confusing i no

No offence but Finnegans Wake makes more sense than that post.

Take it slow, use punctuation, and don't scrimp on the typing. i.e no becomes know, etc. Put a few paragraphs in, too, as it's totally stream of consciousness.

 

[Mile-O]

Do you simply mean you want the form to start on a New Record?

 

[daneo2k3]

no i want the form blank when i open it, so somehow when i fill in the form it saves the details, but then when i open the form i want it to come open blank with no details on it. sorry bout the title.

 

[Travis]

What is your table structure?

Do you have one table for the Purchase orders and one table for the Line Items?

If you do then you could use a Form/Sub Form Design and Use the Parent/Child Relationship between the forms.

Of course without understanding your table structure I can only guess what you are trying to ask for.

 

[Mile-O]

To me it reads like they need to bind the form to the recordset they need and then open the form up as DataEntry.