Filter Subform

[Nylex]

I am now on my final stage of our Stock and Invoicing system which I would
never have got to without this site
I am completely lost on using filters
I want a small Main form which will have a drop down list so that they can
only select a Client that is in our database
I then want to put a subform which I think should be in Datasheet format and
it will find all the transactions for this client ie: Invoice Credit Payments
etc
Each time they change the Clients name I want the subform to show all
entries for the new client – it is important that they not be allowed to
alter any of the records that show up as I did not want to put all the
different controls and formulas into this simple lookup form
I have created the Main Form and I can create a sub form as a datsheet if
this is the best way to go, but how to connect them and make them work I have
no idea
Tks in advance

 

[Armen Stein]

I want a small Main form which will have a drop down list so that they can
only select a Client that is in our database
I then want to put a subform which I think should be in Datasheet format and
it will find all the transactions for this client ie: Invoice Credit Payments

The "glue" that connects a main form with a subform are the Master and
Child fields. These are properties in the control that contains your
subform. You set the Master Field to the Client combobox on the main
form, and the Child field to the Client primary key field on the
subform. Filters aren't needed for this.

it is important that they not be allowed to
alter any of the records that show up as I did not want to put all the
different controls and formulas into this simple lookup form

Set the Allow Additions and Allow Edits properties of the subform to
False.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Nylex]

I must have an error in my setup - the main form starts with a ComboBox that
is waiting for input and it is marked "Unbound"
When I open the properties in the subform I have set the Edits and Editions
to No
When I try to set the the Master and Child properties it says "can't build a
link between unbound forms"
How do I link them first?

 

[Nylex]

I changed a setting on my subform and it allowed me to set the links

Tks