Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / July 2006

Tip: Looking for answers? Try searching our database.

Criteria doesnt open form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lana - 07 Jul 2006 06:03 GMT
Hi all,

I have the MAIN unbound form with unbound combo [Status1] on it.
Its row source is:
SELECT stStatus.ID, stStatus.Status FROM stStatus ORDER BY stStatus.Status;
(shows status, but doesn't show ID Number)

I choose a value in combo and press button to open another form which is
supposed to show list of records meeting the Criteria specified:

stLinkCriteria = "[PrStatus]=" & "'" & Me![Status1].Column(0) & "'"

([PrStatus] is a number field, that's why i chosen for criteria the
Column(0) - which is ID Number)

But something here is wrong, - when i choose a value in combo and press
button to open another form - it gives me only the window saying "action was
cancelled".

Can anybody help please?
Thank you.
Lana

BTW: I have a provision to show all records in opened form if the combo
[Status1] left empty - that case works all right.

Svetlana - 07 Jul 2006 07:45 GMT
As your StatusID is a number first you don't need the ' '
stLinkCriteria = "[PrStatus]=" &  Me![Status1].Column(0)
Lana - 07 Jul 2006 08:11 GMT
Thank you Svetlana!!!
I deleted quoters and it worked!!!!
Lana

> As your StatusID is a number first you don't need the ' '
> stLinkCriteria = "[PrStatus]=" &  Me![Status1].Column(0)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.