A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combo box based on another combo box



 
 
Thread Tools Display Modes
  #1  
Old May 21st, 2008, 03:53 AM posted to microsoft.public.access.forms
acccessaccess2003
external usenet poster
 
Posts: 5
Default Combo box based on another combo box

I have two combo boxes, cboCategory and cboLookup. With the selection of a
category in cboCategory will filter the items in cboLookup. I made reference
to http://allenbrowne.com/ser-27.html Option 2: Pop up a form using another
event such as a DblClick event.
My problem is when I select a particular category in cboCategory and it
happens that there's no items in cboLookup for that category, upon double
clicking will bring me to the form that I want. However, if that category has
items in cboLookup and upon double clicking, the form that is supposed to be
opened, does not appear. I tried using a text box to debug whether upon
double clicking the item present in that category, will the executor enter
the subroutine DblClick event but apparently, it doesn't.

The Row Source of cboCategory is as such:
SELECT tblCategory.[Category ID], tblCategory.[Category Name] FROM
tblCategory ORDER BY [Category Name];

The Row Source of cboLookup is as such:
SELECT tblGasInfo.[Component ID], tblGasInfo.[Gas System], tblGasInfo.Size,
tblGasInfo.Grade, tblGasInfo.Manufacturer FROM tblGasInfo WHERE
(((tblGasInfo.[Category ID])=Forms!frmCombo!cboCategory)) ORDER BY [Component
ID];

Component ID is of text type and the subroutine is as follows:
Private Sub cboLookup_DblClick(Cancel As Integer)
Dim rs As DAO.Recordset
Dim strItemSelected As String
Const strcTargetForm = "frmGasInfo"

' Set up to search for the current Component ID.
If Not IsNull(Me.cboLookup) Then
strItemSelected = "[Component ID] = '" & Me.cboLookup.Column(0) & "'"
Me.txtDebug.Value = strItemSelected
End If

'Open the editing form.
If Not CurrentProject.AllForms(strcTargetForm).IsLoaded Then
DoCmd.OpenForm strcTargetForm
End If
With Forms(strcTargetForm)
' Save any edits in progress, and make it the active form.
If .Dirty Then .Dirty = False
.SetFocus

If strItemSelected vbNullString Then

' Find the record that matches the combo.
Set rs = .RecordsetClone
rs.FindFirst strItemSelected
If Not rs.NoMatch Then
.Bookmark = rs.Bookmark
End If
Else
' Combo was blank, so go to a new record.
RunCommand acCmdRecordsGoToNew
End If
End With
Set rs = Nothing
End Sub

I did the exact same thing for Form_AfterUpdate.
Can anyone tell me what's wrong? Any help is appreciated.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:32 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.