Moving Legos - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Moving Legos

Juan C Rivera

5 years ago

Richard, Alex, Adam good Morning from Japan.
Question, not a real problem but just wondering.
On the order invoice Order lisF is built on a query. I tool the contact form of the customer form and placd the orderlistF in its place (I moved the leggo) It filters the form to show only the orders from the customer. I playd with the query to show only orders not ship, paid is ok but when its gone I dont wish to see it. then I open the orderlistf and I wish to see it all.
Is it possible to use one form with 2 SQL statement, that can detect if its a sub form use sql A, if its just a form use SQL B?
As you say you showed my how to play with the parts Dont know if this is even possible but you always have a trick or two for things like this...

V/r
Juan

	Adam Schwanz @Reply 5 years ago
If im understanding you right, just make an event on the on current of your main form with the subform to apply the sql to the subform. Then when you open it not as a subform it would still have its default sql.

	Adam Schwanz @Reply 5 years ago
Subforms are kind of tricky to code I THINK you'd want something like this with your fields in the on current of the main form. Forms!OrderF!OrderSubF.Form.recordsource = your SQL

	Richard Rost @Reply 5 years ago
Yep. Adam has it. Set the RecordSource to whatever you want to see when you JUST open the form. Then if you open it as a subform, I would put an OnOpen event in the parent that changes the subform's recordsource.

	Juan C Rivera OP @Reply 5 years ago
Going to try it sound good. Big Thank to you guys. V/r Juan

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View