N
neville21
Hi
I wonder if there is someone who can help a novice!
I have a Main Form with "placeholder subform" and a combo box that is used
to show the correct subform (ie select case - placeholder = subform1, etc)
after "update"
When the subform open dafault data is created depending on data in the
mainform and entered.
The froms all have a one - one relationship with ID common - the mainfrom
is an autonumber , the subforms create and ID based on the maon form .
The problem that I have is that if the user fisrt clicks on the 1st in
thelist and opens subform1 then changes his mind and opens subform2 then the
SubTable1 has infomation collected that is not needed. I have conlcuded that
when the combo box is re "updated" the previous record in Table1 should be
deleted to clean the table
The data is medical, the Mainform is collecting demographics and the
combobox is for the type of surgery and the subforms are collecting that
info. I cannot have a patient getting both a knee replacement and a hip
replacement!
Any thought and idea will be gratefully received!
Many thanks
Neville
I wonder if there is someone who can help a novice!
I have a Main Form with "placeholder subform" and a combo box that is used
to show the correct subform (ie select case - placeholder = subform1, etc)
after "update"
When the subform open dafault data is created depending on data in the
mainform and entered.
The froms all have a one - one relationship with ID common - the mainfrom
is an autonumber , the subforms create and ID based on the maon form .
The problem that I have is that if the user fisrt clicks on the 1st in
thelist and opens subform1 then changes his mind and opens subform2 then the
SubTable1 has infomation collected that is not needed. I have conlcuded that
when the combo box is re "updated" the previous record in Table1 should be
deleted to clean the table
The data is medical, the Mainform is collecting demographics and the
combobox is for the type of surgery and the subforms are collecting that
info. I cannot have a patient getting both a knee replacement and a hip
replacement!
Any thought and idea will be gratefully received!
Many thanks
Neville