How to give a default value without lookups?

[prabha_friend]

If I include that in the datasource, the underlying query becomes an unupdatable one :banghead:

 

[RuralGuy]

Does this post belong with a different thread?

 

[daameta]

give more detail about your question

 

[arnelgp]

Use the load/before insert event of your form:

private sub form_load()
me.textboxname = value
end sub

private sub form_beforeinsert(cancel as integer)
me.textboxname = value
end sub