Put a value in the fiels of a new regord on an opening form

[merciers]

Hi
An Access VBA newbie question

I have

• a plublic variable Pub_Numero_Client
• a btn opening a form via the vba command DoCmd.OpenForm sDocName, acNormal, , , acFormAdd

My issue is to put Pub_Numero_Client in the field id_client of the new created record

Probably trivial but I have been trying a lot of things without any success


Can you help me ?

Regards

[Welshgasman]

You could try in the Current Event or Before Insert of the form (depending on whether you want to see it or not)

If Me.NewRecord then
    Me.ID_Client = Pub_Numero_Client
End If

[Gicu]

Because you open the new form in data add mode you can use the default value property of the ID_client textbox. Open the form in design view, click on the ID textbox and in the Default Value property (on the Data tab of the Properties window) enter =fnNumero_Client

Finally just add this public function to a standard module:

Public Function fnNumero_Client() as Long
   fnNumero_Client=Pub_Numero_Client
End Function

Cheers,

[merciers]

Hello Welshgasman and Vlad

Thank you for your replies.
I had tried them and it did not work and so I was wondering it did not work because the record was not really created and so I had tried to play with the events Load or activation of the formula.

But with your replies telling me I was in the good direction ,I just realize ( at last ) that my issue is that the field id-client is considered at a list control in my formula.
I will try to modify that and will tell if I am successful.

Anyway thank you for your help

[Gicu]

Can you please show us what you mean by

is considered at a list control in my formula

? Maybe you can upload a small db sample with just the form(s) and tables involved so we could have a look.

Cheers,

[merciers]

Hello Welshgasman and Vlad

Sorry Vlad I was not very clear and precize but I won !!! With your help I have been able to fixt it. It works well now.


Thanks a lot to you both

[Gicu]