Open a form

[margaret]

So, once again for all you who are reading today, I have a form ... frmSales
that is based an a qrySales from tblSales, it includes a field "fairdate". I
would like the control tblsales.fairdate to read from tblControlFile!fairdate
AND filter any data to equal the tblControlFile!fairdate. On the "on open"
property I have

Me.fairdate.DefaultValue = "'" & DLookup("FairDate", "TblControlFile") & "'"
Me!fairdate = tables!tblcontrolfile.fairdate



And, it's not working. Can anyone help?

Margaret

 

[tina]

already answered in microsoft.public.access.forms under Subject: Open a
filter and default value.

please don't multipost. for more information, see
http://home.att.net/~california.db/tips.html#aTip10