A
Andre C
I have a dilema I cannot solve well.
The form is showing data of clients (based on table "Contacts" and a
subform (based on table "admitanddischarge") shows who has looked
after clients over time. potentially the client is admitted and
discharged to the service several times over the years.
The user can add a new admit date in the subform which is presented as
a dataset view. (The main form is a classic form layout.) One of the
fields allows you to choose your name. This is done witha combobox
looking to another table which contains employees names. Simple enough
and works you might say.
Trouble is looking back in history. This employee table has a field
which says whether the employee is still employed. This is either "Y"
or "N". naturally I want to see all the history of employees, but when
I select the combobox drop down bit I only want to have a list of
curently employed people. This I cannot do. If I change the control
source to filter on "Y" instantly my unemployed disappear fromteh
dataset view. is there anyway around this.
Alternatively I have thought about just displaying a subform with the
data but not allowing data entry there. Instead I would use text and
combo boxes on the main form to enter the data. But how do I get that
data to the table upon which the subform is based as a new record.
i.e. the person calls up the clients details, enters a new admit date
and name on the main form and this data must be added to the table
"admitanddischarge" as a new record.
ACC
The form is showing data of clients (based on table "Contacts" and a
subform (based on table "admitanddischarge") shows who has looked
after clients over time. potentially the client is admitted and
discharged to the service several times over the years.
The user can add a new admit date in the subform which is presented as
a dataset view. (The main form is a classic form layout.) One of the
fields allows you to choose your name. This is done witha combobox
looking to another table which contains employees names. Simple enough
and works you might say.
Trouble is looking back in history. This employee table has a field
which says whether the employee is still employed. This is either "Y"
or "N". naturally I want to see all the history of employees, but when
I select the combobox drop down bit I only want to have a list of
curently employed people. This I cannot do. If I change the control
source to filter on "Y" instantly my unemployed disappear fromteh
dataset view. is there anyway around this.
Alternatively I have thought about just displaying a subform with the
data but not allowing data entry there. Instead I would use text and
combo boxes on the main form to enter the data. But how do I get that
data to the table upon which the subform is based as a new record.
i.e. the person calls up the clients details, enters a new admit date
and name on the main form and this data must be added to the table
"admitanddischarge" as a new record.
ACC