C
CDF
Hi,
I need to search for criteria found in a subform which when found then
changes (goes to) the record in the parent form.
I've got 2 tables (tbl_Customer & tbl_Vehicle) linked by a Customer_ID
field with a 1:Many relationship (1 customer (Customer_ID (PK)) can
have many vehicles (Customer_ID (Fk))).
On the Customer Form there's a subform showing the customers Vehicle/s
in list form.
Each vehicle has a VIN (Vehicle ID No) field and Registration field
both of which are unique to each vehicle in the vehicle table.
I would like to search for a customer (while in the customer form) by
VIN or Rego (I will have a button for each on the Customer Form).
What code do I need to put in the properties for these buttons??
I'd prefer a pop up window (or form) requesting the information
instead of Access' 'Find & Replace' box.
What's the best way to go about this?
I'm not a programmer but have an understaning of the VB code if told
what and where to put it.
Thanks in advance.
I need to search for criteria found in a subform which when found then
changes (goes to) the record in the parent form.
I've got 2 tables (tbl_Customer & tbl_Vehicle) linked by a Customer_ID
field with a 1:Many relationship (1 customer (Customer_ID (PK)) can
have many vehicles (Customer_ID (Fk))).
On the Customer Form there's a subform showing the customers Vehicle/s
in list form.
Each vehicle has a VIN (Vehicle ID No) field and Registration field
both of which are unique to each vehicle in the vehicle table.
I would like to search for a customer (while in the customer form) by
VIN or Rego (I will have a button for each on the Customer Form).
What code do I need to put in the properties for these buttons??
I'd prefer a pop up window (or form) requesting the information
instead of Access' 'Find & Replace' box.
What's the best way to go about this?
I'm not a programmer but have an understaning of the VB code if told
what and where to put it.
Thanks in advance.