OnEvent Click and a Form Tab Control

[Guest]

Good Day Everyone..

I am working on a new project and I just slammed into a wall and need help.

I have a form with a subform inside of it. The subform has the following
fields: ShipTo, BillTo, Account Name. The subform is tied back to the table
called Customers where all of the data resides for each customer. The form
also has a Tab on it which contains the fields for all of the customer
information. I would like to click on the subform and send the data for that
customer to the tab. Unfortunately, I keep hitting a wall when writing the
code for this. Can anyone help?

Thanks,
Jim

 

[Guest]

Send what data?

Steve

 

[Guest]

I apologize. I should have been more clear. I want to send the data for the
selected line of the subform to the unbound textboxes on the Tab Control.
This would require the unbound boxes hitting the main table and match based
upont the selected Shipto.

I hope that is clearer then mud.

Jim

 

[Guest]

Just set the controlsource of the unbound textbox's to:
=Me!mysubform.Form.mysubformfield
change the names to represent your subformcontrol and field names.

Steve

 

[Guest]

Steve..

I have to say that we are missing each other some how on this. The subform
is a small sample of the actual data in the primary table. The table itself
has the following fields:
Shipto, Billto, Account Name, Contact, Phone, Fax, Address1, Address2, City,
State, Zip.

The subform is a quick look at the list of customers: Shipto, Billto,
Account Name.

The intent is to click on the line of my subform and send all of the data
for that customer to the appropriate fields on the Tab Control. That way I
can display my customer information by clicking on the subform.

Does that begin to clear up the confusion or am I confused?

Thanks again,
Jim

 

[Guest]

So your subform is not linked to your main form?

If you have a form in a tab that is based on the table of records, you could
use the current Primary Key and set the filter of the other form, or if used
as the criteria of a query and your other form is based on that query, you
could just Requery the other form...

Steve