Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

The WhereCondition in OpenForm has no effect

Status
Not open for further replies.
awpinf

awpinf

Programmer
Apr 16, 2007
1
SE
On occasion the WhereCondition in the method OpenForm does not perform what it should. It seems that the form is already stuck with a previous used value in an earlier attempt to open the form.

I have verified that the WhereCondition parameter is actually set before calling OpenForm but it still does not work.

If I manually open the form, enter design mode, reset the property "Server Filter", close the form and save and then retry the OpenForm method with the WhereCondition it works!!!

What is going on??
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
670
Andrzejek
Andrzejek
Drago1920
  • Locked
  • Question
Finding the lowest date
Replies
2
Views
337
Andrzejek
Andrzejek
feipezi
  • Locked
  • Question
How to get the macros back as they vanish somehow in a AccessDB?
Replies
8
Views
535
combo
combo
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
2K
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Open New Access Database and Maximise the Application Window
Replies
0
Views
338
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top