loading empty form

[Suzie2012]

I currently have 2 forms, one is a list of customers, the other CustomerDetail form. when i click on a customer ID im wanting it to load the customers details.

right now it is loading a blank CustomerDetails form.

On the customer List form the ID the Is Hyperlink is set to YES; On Click Macro: OPEN FORM.
Form Name: Customer Details
View: Form
Where Condition: [CustomerID]=[Forms]![CustomerDetail]![CustomerID]

On the CustomerDetail Form:
Fetch Defaults: Yes
Filter On Load: No
Order By on Load: Yes
Wait For Post Processing: No
Data Entry: No
Allow Additions: Yes
Allow Deletions: No
Allow Edits: Yes
Allow Filters: Yes


Record Locks: No Locks

[live2ride]

add vba to after update on list
docmd.openform "CustomerDetail",,,"CustomerID = " & me.CustomerID

another method is to add CustomerDetails form on the Main form as subform then go to property sheet (f4) under Data link "Link Master Fields" and "Link Child Fields" set CustomerID for both fields

[John_G]

Hi -

I think your mistake is here:

Where Condition: [CustomerID]=[Forms]![CustomerDetail]![CustomerID]

The form name there should be your first form, where you select the customer ID (you did not say what the form name was), not CustomerDetail.

John

[Suzie2012]

John,
your suggestion worked, part way anyway. it is now working if i open up the CUstomerList form from the navigation panel, then click on one of the hyper links.

I have a Main Form, which has tabs, one of the tabs is the CustomerList form. If i click on hyperlink from there it is asking for the parameter value for [Forms]![CustomerList]![CustomerID]

[John_G]

Hi -

I don't use hyperlinks much, and I don't have A2010 yet, so I have to pass this one to the experts in such things.

Sorry about that.

Anyone?

John

[Suzie2012]

I got the issue corrected,
i set a temp var, and referred back to it for the value i needed for the CustomerID