Form to handle single row table

M

mscertified

I'm designing a form to specify filtering for a recordset. I'd like the form
to display the filtering currently in effect. The only way I can think to do
this is to save the filtering specification in a single-row table so it can
be redisplayed. This will be trickly since I must cater for an empty table
the first time the user uses this screen but thereafter prevent any further
inserts or deletes.
Anyone done this before and got any input?
 
K

Klatuu

You don't need a table. Just refer to the Filter property in the Control
Source of a text box. You can't use Me, however. You need to specifiy the
form name:
Forms!MyFormName.Filter
 
K

Klatuu

Maybe I misread the post the first time. If you intend to use the control to
enter the filter property, the Control Source is not the best place to put
it. Instead, use the Default Value property.
 
Top