How to design a sub form for data entry?

siamandm
5StarLounger
Posts: 1192
Joined: 01 May 2016, 09:58

How to design a sub form for data entry?

Post by siamandm »

Hello All,
if i have a form, lets say for cutstomer and and a sub form for adding several orders for the same customer,
i have created a continuse sub form for the main form customer, which i think it is wrong .. .there is other correct way to design the sub form any one can advise.

Regards

EileenStifone
NewLounger
Posts: 9
Joined: 16 Aug 2022, 05:39

Re: How to design a sub form for data entry?

Post by EileenStifone »

From what you said it wouldn't seem wrong.
If you could see what you have accomplished it would be best, post a sample file on a data sharing site like Dropbox or something else.

User avatar
HansV
Administrator
Posts: 78238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to design a sub form for data entry?

Post by HansV »

You can use a continuous subform based on the order table, and place it on the main form based on the customer table. I have often used such a design.

Here is a screenshot from a very old Northwind database:

S1758.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

siamandm
5StarLounger
Posts: 1192
Joined: 01 May 2016, 09:58

Re: How to design a sub form for data entry?

Post by siamandm »

Thank you very much