Delay loading data

[CJ]

Hi Groupies

I am wondering if it is possible to have a form load but not show any data
until selections are made in two unbound cascading combo boxes?

The form in question is bound to a table record source but I don't want any
data to show until the cascading combos are used as filters. I can not use
them as filters of the record source (if I make it a query or sql) or else
nothing at all shows up when the form loads.

When the form loads, it is displaying data from the first record in the
table. This form can not be used for adding new records, just editing
existing, so I can not make it go to a new record.

I suppose I could cheat and Allow Additions and make it open to the new
record so that everything is blank or 0 but I wondered if there was a more
correct way of doing this.

 

[PieterLinden via AccessMonster.com]

set the recordsource of the form after the filtering controls (unbound) have
been filled in.

 

[CJ]

Hi Peter

Thanks for the suggestion.

How would I go about implementing that?