A
ABW
Greetings all:
I've been working on this problem for some time. I've got a form/subform
application where a user logon into the application filters the available
record seen on the main form. The sub form shows several textboxes for the
categories x 4 weeks per record, as well as, some labels displaying totals.
What I'd like to do is eliminate the form's record selectors and just allow
the combo box that displays the months of the year serve as the record
selector. I've setup the sub form to assume that the current month is the
month to be edited and to open the record to the current month. If however
an employee changes months (i.e. post dates or makes corrections to data)
I'd like the application to see if a record exists for the selected month
and if so, display the data. If there is no record, create a new record.
My problem is that when I change the combo box I'm able to populate all the
textboxes except the one holding the bound primary key. Is it possible to
have the combo box serve as the record selector?
If it is not possible, how can I prevent the user from opening the
application (to record # 1), changing the combo box to a different month and
over-writing record # 1's data?
All responses and help are greatly appreciated.
I've been working on this problem for some time. I've got a form/subform
application where a user logon into the application filters the available
record seen on the main form. The sub form shows several textboxes for the
categories x 4 weeks per record, as well as, some labels displaying totals.
What I'd like to do is eliminate the form's record selectors and just allow
the combo box that displays the months of the year serve as the record
selector. I've setup the sub form to assume that the current month is the
month to be edited and to open the record to the current month. If however
an employee changes months (i.e. post dates or makes corrections to data)
I'd like the application to see if a record exists for the selected month
and if so, display the data. If there is no record, create a new record.
My problem is that when I change the combo box I'm able to populate all the
textboxes except the one holding the bound primary key. Is it possible to
have the combo box serve as the record selector?
If it is not possible, how can I prevent the user from opening the
application (to record # 1), changing the combo box to a different month and
over-writing record # 1's data?
All responses and help are greatly appreciated.