B
benjamin
Hi! Sorry for that uninformative title.
Basically i am creating a form with a subform which will query for customer
data based on 2 address lines. It works fine but only for existing
customers. I tried writing some codes to check if the customer existed using
VBA but it doesn't seem to work.
1) Created an event procedure to call up code for querying the subform.
2) need the codes for checking if the query is generating results.
3) if yes proceed as normal
4) if no, prompt for user action, new custome a/c creation etc...
Thank you
Basically i am creating a form with a subform which will query for customer
data based on 2 address lines. It works fine but only for existing
customers. I tried writing some codes to check if the customer existed using
VBA but it doesn't seem to work.
1) Created an event procedure to call up code for querying the subform.
2) need the codes for checking if the query is generating results.
3) if yes proceed as normal
4) if no, prompt for user action, new custome a/c creation etc...
Thank you