Updating main form from subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sorry I previously posted this in the wrong topic Wont't do it again.

I have a tabbed form which works fine other than the fact that when I change
tab, the record field [ComplaintNumber] located on the subform of main form
does not update on the other tabs, meaning on the main form, as these if I
get it right are just extensions of the main form.

The [ComplaintNumber] is defined on a subform placed on main form.
On the main form when I choose a customer ID, the complaintNumber is created
by an expression on the sql statement followed by an auto number. It looks
like this:
Customer ID number: PEC-12
ComplaintNumber: PEC-12-112

I need to see this number updated on the other tabs, which are also based on
the main form and other tables, so that I can add corresponding data for this
particular record.
I have the OnChange and OnClick events from the Tab form properties, byt to
avail.

Many Thanks,
Chris1
 
How many tables do you have and what are the relationships. I suspect you
are making this more difficult than required.
 
I have TblCustomer and TblComplaintPhase1: The main form (tab form) is based
on a query using both tables.
The other two tables are: TblFullResponsePhase2, and TblFullInvestigation3

relationships:
1 to many between TblCustomers and TblComplaintPhase1
1 to many between TblComplaintPhase1 and TblFullResponsePhase2
1 to many between TblComplaintPhase1 and TblFullInvestigation3
1 to many between TblFullResponsePhase2 and TblFullInvestigation3

Possible scenarios are:
Phase 1 + Phase 2 + Phase3
Phase1 + Phase3

Many thanks,
Chris.


scubadiver said:
How many tables do you have and what are the relationships. I suspect you
are making this more difficult than required.



Chris said:
Sorry I previously posted this in the wrong topic Wont't do it again.

I have a tabbed form which works fine other than the fact that when I change
tab, the record field [ComplaintNumber] located on the subform of main form
does not update on the other tabs, meaning on the main form, as these if I
get it right are just extensions of the main form.

The [ComplaintNumber] is defined on a subform placed on main form.
On the main form when I choose a customer ID, the complaintNumber is created
by an expression on the sql statement followed by an auto number. It looks
like this:
Customer ID number: PEC-12
ComplaintNumber: PEC-12-112

I need to see this number updated on the other tabs, which are also based on
the main form and other tables, so that I can add corresponding data for this
particular record.
I have the OnChange and OnClick events from the Tab form properties, byt to
avail.

Many Thanks,
Chris1
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form and two Subforms 2
Update subform with combobox change on main form 1
Tabbing between a main form and a subform 1
Copy data from 1 subform to another subform 2
Access Main form/Subform Navigation 0
Main Form with Subforms 5
Main Form with Tab Subforms 1
First Subform record gets modified when closing form 3

Back
Top