J
Jessie
I am fairly new to access. What seemed like a 3 day task
has turned into 3 months and counting.
My database records repairs undertaken. I record customer
details, equipment booked in, a fault description and
repair undertaken. There are two tables, the customer
details table (CustInfo) and the repair table (RepInfo)
mapped as one to many.
I have decided not to use a switchboard method but the
button method to connect the various tasks like
SEARCH for existing customer
ADD NEW CUSTOMER is one does not exist
CAPTURE REPAIR details
PRINT form details
VIEW history of repairs
Etc
My SEARCH form comprises four search combos (unbound) by
CboPhoneNum or CboCellNum or CboCompanyName or CboSurname
and the rest on this form are text boxes (bound). The
searches work.
As the SEARCH and ADD NEW CUSTOMER form are similar I use
the same controls. The bound controls update fine but the
unbound controls have to be forced to update. ( I
use .AddNew and .Update ) The problem with this is that I
have two separate entries of the same record in the
table. Any suggestions.
Alternatively, I create a second form and replace the
four unbound combos with bound text boxes instead and
overlay this on the original form. If this is an option
how best do I implement this.
Thanks in anticipation
has turned into 3 months and counting.
My database records repairs undertaken. I record customer
details, equipment booked in, a fault description and
repair undertaken. There are two tables, the customer
details table (CustInfo) and the repair table (RepInfo)
mapped as one to many.
I have decided not to use a switchboard method but the
button method to connect the various tasks like
SEARCH for existing customer
ADD NEW CUSTOMER is one does not exist
CAPTURE REPAIR details
PRINT form details
VIEW history of repairs
Etc
My SEARCH form comprises four search combos (unbound) by
CboPhoneNum or CboCellNum or CboCompanyName or CboSurname
and the rest on this form are text boxes (bound). The
searches work.
As the SEARCH and ADD NEW CUSTOMER form are similar I use
the same controls. The bound controls update fine but the
unbound controls have to be forced to update. ( I
use .AddNew and .Update ) The problem with this is that I
have two separate entries of the same record in the
table. Any suggestions.
Alternatively, I create a second form and replace the
four unbound combos with bound text boxes instead and
overlay this on the original form. If this is an option
how best do I implement this.
Thanks in anticipation