Form to handle single row table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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.
 
Back
Top