filered form shows blank fields

fanis

Please help me on this one.
I use the docmd.openform "frmName",,,stLinkCriteria expresion to open a form.
For example: stlinkcriteria = "[RecID] = " & 44
Although RecID = 44 exists the form opens with blank fields,but when I check the form's properties i find the filter as: [RecID] = 44.
What is wrong?
Thanks in advance for any ideas.

nico5038

Check that your form has the AllowUpdates property set to True.
Looks tome you open a NewRecord form that will always be empty.
A standard new form will AllowUpdates, so create "plain" form to see the differences.

Nic;o)

dima69

Two things I can think of:
1. RecId is not the name of a field in a form's table or query.
2. RecId has datatype which is not numeric.

fanis

Quote:

Originally Posted by nico5038

Check that your form has the AllowUpdates property set to True.
Looks tome you open a NewRecord form that will always be empty.
A standard new form will AllowUpdates, so create "plain" form to see the differences.

Nic;o)

Yes that did the job thanks a lot !!

nico5038

You're welcome, success with your application !

Nic;o)

filered form shows blank fields

re: filered form shows blank fields

re: filered form shows blank fields

re: filered form shows blank fields

re: filered form shows blank fields

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about