Leading zeros are truncated when passing a value from a data entry form to a vba function

[Iain]

Appologies but I tried to post an error dialogue box with my last post "User-defined Object not defined". I now see that this didn't post correctly.

I wll try these suggestions but I have now discovered that form's VBA code will not compile.

The first line of Function InsertFrames() is highlighted by the Debug Compile tool.

I have the following Object References selected

Visual basic For Applications
Microsoft Access 12.0 Object Library
OLE Automation
Microsoft Office 12.0 Access database Object library
Microsoft ActiveX Data Objects 2.8 Library

Do I need other object libraries selected?

[Iain]

Solved!
By using the modified code in post #13, but leaving the first line as in my original code the incrementation calculation and concatenation, all work as intended.
The code would not compile because of a typo in the variable [Rating] which a copied from #13 but didn't spot. This cleared both the 'User-defined ... error and the failure of the SQL statement.
Many thanks to everone who helped me out on this.
Iain

[June7]

By 'first line' you mean the Set frm?

Your code was working before, right? What was changed?

EDIT: Now I see you solved.

About your code, not sure about need for the frm and cmd objects. Is this code behind the form?

[Iain]

By 'first line' you mean the Set frm?

Your code was working before, right? What was changed?

EDIT: Now I see you solved.

About your code, not sure about need for the frm and cmd objects. Is this code behind the form?

Code I have posted is for the Form with the text boxes. It is a temporary form (not sure if it is strictly speaking a subform or not) opened from the form referrred to by Set frm.

This other form displays previously recorded Camera Image details in a Dynaset so that the user can refer to previous entries and thus check if they are using the correct camera/library references etc.

This Dynaset is re-queried by the code on the data entry form so that it immediately refreshes with the newly entered data.

Trust this answers your question.