select all records in subform

  • Thread starter Thread starter bobolougats
  • Start date Start date
B

bobolougats

Hi all, here is my problem: Currently I have a form that
has a check box that determines whether or not a Customer
is a member. If the customer is a member then they get
the member price, and if they aren't a member then they
get a different price. Right now the Member checkbox
works great EXCEPT that it only changes the price charged
on one of the records in the subform (where the products
are listed.) Is there a macro I can run that will select
all the records in the subform when I check/uncheck the
Member Checkbox? Any other suggestions would also be
greatly appreciated. Thanks!
 
Hi,

You could run a macro, on the after update event of the checkbox, which
runs an update query, to update the records affected, and then refreshes
the subform.

hth

Mark

This information is provided "as is" and confers no rights or expresses no
warranties.
 
Back
Top