S
Stapes
Hi
I am starting this topic again as the older thread seems to be ignored
once it gets a few days old.
I am trying to repair a project involving a form containing a subform
containing a subfrom.
The main form denotes customer details.
The first subform denotes a boat.
The second subform denotes a job on that boat.
At the top of the subform are 3 combo boxes allowing the user to select
either a customer name, a boat, or a customer number.
When a boat is selected, we want to display that boats details, its
owners (customer) details, and jobs done on it.
I have finally got that bit working, with much difficulty.
I had to concatenate together boatname & customer number.
Then unstring them in the AfterUpdate event code.
Then, set the subforms LinkMasterFields and LinkChildFields to the boat
name. (I had to put the boat name into a hidden control on the main
form to make this work).
Now, this works OK.
Trouble is, I now have to reset these LinkMasterFields and
LinkChildFields properties.
If the user then tries to search for a customer, I have tried to set
the LinkMasterFields and LinkChildFields property to point to customer
number, as it is when the form initially loads.
I get a stupid error message:-
Runtime error '2001' : You cancelled the previous operation.
What is that all about, and how can I get rid of it.
Stapes
I am starting this topic again as the older thread seems to be ignored
once it gets a few days old.
I am trying to repair a project involving a form containing a subform
containing a subfrom.
The main form denotes customer details.
The first subform denotes a boat.
The second subform denotes a job on that boat.
At the top of the subform are 3 combo boxes allowing the user to select
either a customer name, a boat, or a customer number.
When a boat is selected, we want to display that boats details, its
owners (customer) details, and jobs done on it.
I have finally got that bit working, with much difficulty.
I had to concatenate together boatname & customer number.
Then unstring them in the AfterUpdate event code.
Then, set the subforms LinkMasterFields and LinkChildFields to the boat
name. (I had to put the boat name into a hidden control on the main
form to make this work).
Now, this works OK.
Trouble is, I now have to reset these LinkMasterFields and
LinkChildFields properties.
If the user then tries to search for a customer, I have tried to set
the LinkMasterFields and LinkChildFields property to point to customer
number, as it is when the form initially loads.
I get a stupid error message:-
Runtime error '2001' : You cancelled the previous operation.
What is that all about, and how can I get rid of it.
Stapes