Listbox, Where statement (1 Viewer)

M

musclecarlover07

Registered User.

Local time

Yesterday, 22:47

Joined

May 4, 2012

Messages

236

• Jul 29, 2013

• #1

So i have a form with 3 fields. (This is just a test form/table):
ID: autonumber
Fullname: text field
Last4: number field

I have the following code:

Code:Copy to clipboard

DoCmd.OpenForm "test", , , "Id = '" & Me.List14 & "'"

It keeps giving a mismatch error. How do i get it so I can use the autonumber to filter the form?

Code:Copy to clipboard

DoCmd.OpenForm "test", , , "Fullname = '" & Me.List14 & "'"

When I do this it works just fine.

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 21:47

Joined

Aug 30, 2003

Messages

36,124

• Jul 29, 2013

• #2

Note no delimiters for a numeric field:

http://www.baldyweb.com/wherecondition.htm

Also note if your listbox is multiselect that won't work.

 

M

musclecarlover07

Registered User.

Local time

Yesterday, 22:47

Joined

May 4, 2012

Messages

236

• Jul 29, 2013

• #3

pBaldy thanks. That helped so much. So now if/when i need to do that with a date I got that. It isnt a multi-select box. I havent really found a use for those within my databases yet.

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 21:47

Joined

Aug 30, 2003

Messages

36,124

• Jul 29, 2013

• #4

Happy to help.