C
CatalinaJenx79
Hi Folks. I am trying to use a form with a subform to create an
invoice management system. I am trying to make the main form Read Only
as it contains the invoice number and customer info. While the subform
will be the editable line items. I have designed both and i like what
i see but the exectution is confusing me. I need to find a method of
directing the user around this form. Currently, the form will allow
all fields to be edited. And being that the form loads with values
from the first record, this record is constantly being edited agaist my
will. I'd like for the input into the first field, "Invoice#", to be
checked against my Invoice Index. A Master file of Invoices. If the
invoice has already been established, the rest of the fields should be
filled automatically from the corresponding record containing that key
in the Recordsource. These fields will be "locked" against editing and
the focus will turn to the subform. If the invoice# is not yet
established, I'd like for the rest of the fields to be "unlocked" and
editable all the way down through the subform. The form would then be
directed to write the data into the table and also write certain info
into the Invoice Index including Invoice# So that those fields will
becom read-only next time the form is run. I realize this is wordy but
plese help.
invoice management system. I am trying to make the main form Read Only
as it contains the invoice number and customer info. While the subform
will be the editable line items. I have designed both and i like what
i see but the exectution is confusing me. I need to find a method of
directing the user around this form. Currently, the form will allow
all fields to be edited. And being that the form loads with values
from the first record, this record is constantly being edited agaist my
will. I'd like for the input into the first field, "Invoice#", to be
checked against my Invoice Index. A Master file of Invoices. If the
invoice has already been established, the rest of the fields should be
filled automatically from the corresponding record containing that key
in the Recordsource. These fields will be "locked" against editing and
the focus will turn to the subform. If the invoice# is not yet
established, I'd like for the rest of the fields to be "unlocked" and
editable all the way down through the subform. The form would then be
directed to write the data into the table and also write certain info
into the Invoice Index including Invoice# So that those fields will
becom read-only next time the form is run. I realize this is wordy but
plese help.