what todo if filtering a query results in none

  • Thread starter Thread starter Harry van Rijn
  • Start date Start date
H

Harry van Rijn

I open a form with a filter set to F
This form is based on a query, and it could happen that some value for F
result in 0 rows. But for creating NEW records, I need this F (filter
value) in this form, but it seems not to be present.
In other words, if I could give the value F as a parameter to the new
form, then I'll be done.
Can someone assist me with this ?
 
I open a form with a filter set to F
This form is based on a query, and it could happen that some value for F
result in 0 rows. But for creating NEW records, I need this F (filter
value) in this form, but it seems not to be present.
In other words, if I could give the value F as a parameter to the new
form, then I'll be done.
Can someone assist me with this ?
Click to expand...

It sounds like you're assuming that a Filter will automatically cause
new records to be entered with the filter value; it won't! All a
filter does is limit the records retrieved from an existing table to
match the filter.

You might want to consider using an unbound Form with a Subform based
on your table, using an unbound textbox as the Master link Field.
Setting this textbox as the Master Link Field will both filter the
subform and also ensure that new records have that value inserted.

If I'm missing the point of your question, please post back!
 
Back
Top