Table field Defaulting to an Open Form?

[Grandkathy]

Is it possible to have the default value in a field default to an open form?

i.e., forms!frmMain.ConfIDHold

Thank you.

 

[ZmrAbdulla]

Yes you can...
Is the form bound?

________________________________________________________
Zameer Abdulla
Help to find Missing people
All cats love fish but fear to wet their paws..

 

[Grandkathy]

No, it's an unound field called ConfIDHold

 

[Grandkathy]

Woops, "Unbound

 

[ZmrAbdulla]

How do you want the default value? is that date or an incrementing number? How do you want to open the form?

Basically your syntax is correct.

[tt]forms!frmMain.ConfIDHold.Value[/tt]



________________________________________________________
Zameer Abdulla
Help to find Missing people
All cats love fish but fear to wet their paws..

 

[Grandkathy]

This would be great if I hadn't been sleeping when I wrote the message, I goofed.

The field I want a default value in is in the table design, and I want the default value to be derived from a form that is already opened.

Thanks for taking your time to answer this.

 

[ZmrAbdulla]

If it is not an incrementing number then you can set the default value in the property of the textbox.

If it is incrementing and you need it automatically then try using
[tt]DMax("[FieldName]","TableName")+1[/tt]
in the Open Event of the form.

________________________________________________________
Zameer Abdulla
Help to find Missing people
All cats love fish but fear to wet their paws..