C
ChuckW
Hi,
I have a form called frmSalesAW with a subform contained in it called
frmCallLogAW. It is based on a query called qryCallLogAW which is based on a
table called tblCallLogAW. There are fields such as BusinessDate,
PhoneDials, AppointmentsMade etc and about 300 records in the table. There
is actually a record for each business day from November 2008 to December
2009. The BusinessDate field is field in with these date values while all of
the other fields are blank. I have created the frmCallLogAW form so that a
sales rep can open the main form and then fill out numeric information into
this form. It is in single form format where the user uses the navigation
buttons to toggle to yesterday or tomorrow. I want to write some vba code
which will always open the form to todays business day with the cursor being
on the field PhoneDials. Can someone help me with that?
Thanks,
I have a form called frmSalesAW with a subform contained in it called
frmCallLogAW. It is based on a query called qryCallLogAW which is based on a
table called tblCallLogAW. There are fields such as BusinessDate,
PhoneDials, AppointmentsMade etc and about 300 records in the table. There
is actually a record for each business day from November 2008 to December
2009. The BusinessDate field is field in with these date values while all of
the other fields are blank. I have created the frmCallLogAW form so that a
sales rep can open the main form and then fill out numeric information into
this form. It is in single form format where the user uses the navigation
buttons to toggle to yesterday or tomorrow. I want to write some vba code
which will always open the form to todays business day with the cursor being
on the field PhoneDials. Can someone help me with that?
Thanks,