Record Creation/Filtering

  • Thread starter Thread starter Pwyd
  • Start date Start date
P

Pwyd

All right. Thanks to Klatuu, i've got a form that opens up a hidden form,
which gets the user's name (which i found needs to exist before applying a
query to it, duh). The data entry form opens up, filtering all of the
records based on this user name, and another query which associates the
username with a Processor's full name. Works beautifully.

Here's my problem. Or question rather. Do i need to build a second form
specifically for data entry into the Recordset, or is there a way to add a
new record to a filtered set of records? On the bottom of the current form,
it has the -> * grayed out.
 
Pwyd said:
All right. Thanks to Klatuu, i've got a form that opens up a hidden
form, which gets the user's name (which i found needs to exist before
applying a query to it, duh). The data entry form opens up,
filtering all of the records based on this user name, and another
query which associates the username with a Processor's full name.
Works beautifully.

Here's my problem. Or question rather. Do i need to build a second
form specifically for data entry into the Recordset, or is there a
way to add a new record to a filtered set of records? On the bottom
of the current form, it has the -> * grayed out.
Click to expand...

Is the new record button grayed out when you open the form un-filtered? I
have seen filters cause an editable form to become read only, but it is
unusual.
 
No, its not. Does a form inherit the access of its "parent" form if the
macro calling it IS from a read-only form? the macro specifies the form
should be opened in data entry mode.
 
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
Pwyd said:
No, its not. Does a form inherit the access of its "parent" form if
the macro calling it IS from a read-only form? the macro specifies
the form should be opened in data entry mode.
Click to expand...

No. What is your filter?
 
My filter is a hidden no-access form that simply gets the user name, since i
need the username to exist before i can filter for it.
 
Pwyd said:
My filter is a hidden no-access form that simply gets the user name,
since i need the username to exist before i can filter for it.
Click to expand...

I mean if you go into records - advanced filter tools it should show you
exactly what your filter is. What do you see there?
 
Back
Top