[email protected]

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

I have a form with a sub form. On this sub form I would
like to select the records based on 2 fields a date and
account. I have been able to do one or the other,
using "link child fields" and "link master fields"
properties. But I don't know how to do both at the same
time.

How do you display only the records that match the two
fields from the main form on a sub?
 
Hi

You can use the Link Child/Master Fields to make a link
between more than 1 field by just entering the fields
separated by semi-colon (;)

e.g. Link Child Fields: DateFieldName;AccountFieldName

hth

Chris
 
Instead of using the link child and master fields, create a
query based on the two fields. Then set the datasource for
the subform to the query, or create a subform based on the
query and replace the existing subform with the new one.
 
it works for the first recored but thier after

i do not know how to requery a subform so the recoreds do
not change as the account or date changes
 
i had already tried this before i posted the first time.

i just tried again and its still not working.

im probably just missing some thing simple but dont know
what it is.

any help would be app
 
Attach event procedures (or macros if you're more
comfortable with them) to the combo boxes. I usually use
the After Update action. In AccessVB:

Forms!MainFormName.SubFormName.Requery
 
Back
Top