How do I do this?

[cubbyamber]

I am attaching my database so you can get a better understanding of what I need.

I want to make a form called clients based on either the clients query or clients table I also want a subform based on my order details table(I can create a query as well) however, when I do a subform using my order details table, I can't use all the fields because there are too many fields and the wizard can't do it.

So how do I get all the various order details connected with the client number.

I want it to work like my clients form but with all the order details information.

By the way, I am a newbie to advanced Access so please bare with me.

Tracy

 

[Banana]

By the way, I am a newbie to advanced Access so please bare with me.

I believe indecent expsoure is illegal. Surely you mean "bear with me"?

To answer your question, I didn't look at your database, but I can tell you that it's much much easier to do this way:

1) Create your client form without the order form. Decide where you want the order subform want to be.

2) Design a new form, make it your order detail subform. Design as you want it to be.

3) Drag the order form from the database window (e.g. the lists of forms) and drop it on the client form's design view.

A pop up will appear ask you how to relate the data. I presume you'll want to use ClientID. Click on that.

Voila!

 

[Uncle Gizmo]

Northwind sample database

How do I get all the various order details connected with the client number

Have you looked at the "Northwind sample database" that comes with MS Access? I believe it is exactly what you are looking for!

 

[cubbyamber]

Yeah, indecent exposure is illegal but I though I would see if anybody else wanted to streak with me LOL.

Anyways, I tried you solution and it worked great except, now my main form is all scrunched up. Any suggestions? I attached the database in case you wanted to see it. The form is clients the subform is order details.

Trac

 

[cubbyamber]

Never Mind, I got it.

Tracy