form question

[Jessica]

Hello All,

I have a multi tabbed form which enters data into one table. The reason
I used a multi tabbed form is to make it easier when the user inputs
data because certain fields only pertain to a certain primary key field.
My question is that each tabbed form has a unique field is there a way
to set it up so that it only shows the records if that unique field has
data in it?

TIA,
Jessica

 

[Rick Brandt]

Hello All,

I have a multi tabbed form which enters data into one table. The reason I used
a multi tabbed form is to make it easier when the user inputs data because
certain fields only pertain to a certain primary key field. My question is
that each tabbed form has a unique field is there a way to set it up so that
it only shows the records if that unique field has data in it?

Unclear. Do you have a single form with a TabControl or do you have a main form
that contains subforms (with the subforms on TabPages)?

Having a form and subforms point to the same table is not a good idea as you
will get write conflicts (with yourself).

Please clarify.

 

[Jessica]

Hi Rick,

I made a single form that has multiple tabs for entering data into a
main table. I did it this way because not all the fields in the table
need to be filled in for a certain upc number. So to eliminate mistakes
of a user entering data into a field that doesn't belong there I made a
tabbed form with the needed fields. And was just wondering if I could
get it so when they go to a tab that it would only show records if a
certain field has data in it instead of showing all the records in the
table.

Jessica

 

[Rick Brandt]

Hi Rick,

I made a single form that has multiple tabs for entering data into a main
table.

Makes sense so far...

I did it this way because not all the fields in the table need to be filled in
for a certain upc number.
Ok...

So to eliminate mistakes of a user entering data into a field that doesn't
belong there I made a tabbed form with the needed fields.

You just lost me.

And was just wondering if I could get it so when they go to a tab that it
would only show records if a certain field has data in it instead of showing
all the records in the table.

More confusion. Is this a continuous form that shows more than one record at a
time (as rows)? In a single record view form you would see ONE set of fields
distributed across the TabPages and those fields will either have data in them
or they won't. You could certainly apply a test that would hide certain
TabPages on records where those fields should not be filled out or alternatively
show the TabPage, but gray out all of the controls to indicate that they are not
appropriate for the current record.

If you are using a continuous form and want each tab to only show rows where
(some test) is true then you would either need to use subforms or dynamically
apply different filters to the form as each TabPage is selected. The problem
with this is you will lose your "place" each time you apply a filter. You would
need to store the Primary Key of the current record so that after applying the
filter you could use that value to return to the same record.