Modify code (Access 2003)

Topic

New Reply

Using the code below to open a form based on the SiteID. It works well but is there a way to modify this using a wildcard to show all like IDs? Example below. Thanks..

SiteID = 1234A

Show sites = 1234b and 1234c and 1234d

DoCmd.OpenForm “Site_Frm”, , , “SiteID=” & Chr(34) & Me.SiteID & Chr(34)

Reply | Quote

Replies

You can use

DoCmd.OpenForm "Site_Frm", , , "SiteID Like " & Chr(34) & Me.SiteID & "*" & Chr(34)

Reply | Quote

Hans it got me close butt.. I think I I didn’t exlpain it right..

What I need is?

My query shows the site as 1234A I need all sites like 1234* This showed only 1234A when I ran it. SO we need the last character removed and show all sites like 1234*.. Make sense>? Thanks..

Reply | Quote

OK, try

DoCmd.OpenForm "Site_Frm", , , "SiteID Like " & Chr(34) & Left(Me.SiteID, Len(Me.SiteID) - 1) & "*" & Chr(34)

Reply | Quote