open form, link criteria, filter, cant set default value to a control.. why?

antonyx

Arsenal Supporter
Local time
Today, 17:52
Joined
Jan 7, 2005
Messages
556
Code:
Private Sub btncard_Click()
Dim stLinkCriteria As String
DoCmd.RunCommand acCmdSaveRecord
stLinkCriteria = "[jobref]=" & "'" & Me![jobref] & "'"
DoCmd.Close
DoCmd.OpenForm "k_job_card", , , stLinkCriteria
End Sub

this button code opens the k_job_card form.

the form opens and says 'Record 1 of 1, (Filtered)

i have a control on the form that opens.. and i am simply trying to assign a default value to that control..

it is a textbox.. for my jobtype field (text datatype)..

is there any particular reason why i cannot assign a default value to a control if it has been placed on a form that has been opened using a form filter?

this is how the Form Data tab is set at the moment..
 
Last edited:
Is your site down at the moment? I can't get the pic.
 
i think its working now
 
the website picture is working i mean.. the actual problem still persists..

can anybody give me some useful advice regarding filter form default values?
 

Users who are viewing this thread

Back
Top Bottom