Buster Aldrich
New member
- Local time
- Today, 16:12
- Joined
- Apr 5, 2020
- Messages
- 6
I am trying to open a form in access 2007 Frm_LabelToPrint_Config and check for any records.
The code will then take actions if there are records.
Other actions if the recordset is empty.
The form is bound to a table Tbl_LabelsToPrint_Config
Here is the code for this
DoCmd.OpenForm "Frm_LabelsToPrint_Config"
If DCount("*", [Frm_LabelsToPrint_Config].RecordSource) > 0 Then
and a series of actions
The form is opening and there are records as per the attached pdf.
The debug shows the line
If DCount("*", [Frm_LabelsToPrint_Config].RecordSource) > 0 Then
as the culprit.
I'm sure that it is an easy answer and I have always found it is me and not Access making the mistake.
Any advice would be greatly appreciated.
The code will then take actions if there are records.
Other actions if the recordset is empty.
The form is bound to a table Tbl_LabelsToPrint_Config
Here is the code for this
DoCmd.OpenForm "Frm_LabelsToPrint_Config"
If DCount("*", [Frm_LabelsToPrint_Config].RecordSource) > 0 Then
and a series of actions
The form is opening and there are records as per the attached pdf.
The debug shows the line
If DCount("*", [Frm_LabelsToPrint_Config].RecordSource) > 0 Then
as the culprit.
I'm sure that it is an easy answer and I have always found it is me and not Access making the mistake.
Any advice would be greatly appreciated.