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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

The following is not working - can

Status
Not open for further replies.
Moss100

Moss100

Technical User
Aug 10, 2004
586
GB
The following is not working - can someone show me the correct version - Thank you Mark

Code: 
Me.Form.Filter = "[Prop_Elec_Safety_Reminder] = False And [Prop_Status] = 'Let' And [Prop_Type_ID_Link] <> 24"
 
Sort by date Sort by votes
Hi Duane - thanks for your input - I realise that I have set - [Prop_Elec_Safety_Reminder] = False (It should be true).

Couldn't see the wood for the trees!!

Thanks for your time. Regards Mark













 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Field is being rounded in the export process
Replies
17
Views
406
strongm
strongm
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
447
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
Can not get Access 2016 queries to accept form value input or TempVars! input 2
2
Replies
21
Views
473
TheresAlwaysAWay
TheresAlwaysAWay
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
867
combo
combo
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
159
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top