Record Creation/Filtering

[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.

 

[Rick Brandt]

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.

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.

 

[Pwyd]

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]

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]

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]

Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.

 

[Rick Brandt]

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.

No. What is your filter?

 

[Pwyd]

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.

 

[Rick Brandt]

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.

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