George-Bowyer
Registered User.
- Local time
- Today, 23:28
- Joined
- Dec 21, 2012
- Messages
- 178
Hi,
I am building a web database that lists customers and events.
Each customer can go to several events, each event can have several customers.
When you open the Customer Form, there is a sub-form showing all the Events he is going to.
If you double-click an Event, it opens the event form.
On the Event Form, there is a sub-form showing all the customers going. Double-click a customer and it opens the customer form.
And vice versa.
All this works fine (handled by a 3 field "CustomerEvent" table that pairs up IDs).
What I am trying to address is the occurrence when a User selects a customer, selects an event from the sub-form and then tries to select a different customer from the event form's sub-form.
Sequence of events:
Open Customer Form (CF1). CF1 has focus.
Double-click Event on CF1.
Event Form (EF1) Opens. EF1 has focus.
Double click 2nd customer on EF1.
What happens: CF1 changes to the 2nd customer, but focus remains on EF1, so CF1 is invisible.
What I want to happen: CF2 opens with 2nd customer information and gets focus, leaving EF1 and CF1 open (unchanged) underneath.
What I could live with happening: CF1 changes to 2nd Customer and gets focus.
How can I achieve this, please?
I hope this makes sense.
This is a web database so no answers requiring VBA, please.
I am building a web database that lists customers and events.
Each customer can go to several events, each event can have several customers.
When you open the Customer Form, there is a sub-form showing all the Events he is going to.
If you double-click an Event, it opens the event form.
On the Event Form, there is a sub-form showing all the customers going. Double-click a customer and it opens the customer form.
And vice versa.
All this works fine (handled by a 3 field "CustomerEvent" table that pairs up IDs).
What I am trying to address is the occurrence when a User selects a customer, selects an event from the sub-form and then tries to select a different customer from the event form's sub-form.
Sequence of events:
Open Customer Form (CF1). CF1 has focus.
Double-click Event on CF1.
Event Form (EF1) Opens. EF1 has focus.
Double click 2nd customer on EF1.
What happens: CF1 changes to the 2nd customer, but focus remains on EF1, so CF1 is invisible.
What I want to happen: CF2 opens with 2nd customer information and gets focus, leaving EF1 and CF1 open (unchanged) underneath.
What I could live with happening: CF1 changes to 2nd Customer and gets focus.
How can I achieve this, please?
I hope this makes sense.
This is a web database so no answers requiring VBA, please.
Last edited:
