Combo Box Posts

As this is my first post to this board, I will try not to complicate this with unnecessary information. I am trying to set a combo box to a specific value (the name of a loan) using VBA for when the form opens. The combo box is populated with Loan Names from an Access table. Currently, I am using the following code to set the list index property (I have used this with excel vba before and it worked):   Combo_LoanName.ListIndex = 3  The problem is that when the form opens the combo box list is populated but no item is selected. I have tried other variations of the code above but to no avail. Can anyone spot what I may be missing?   Thanks, Craig

Posted to MB Topic: Access VBA Programming « Access Board

Hi there,, , Does anyone know how to clear the text dispplayed in a combo box? Mine just holds the last value and doesn't overwrite it when I tab back to it ideally I want it cleared and ready for the next entry. , , I've tried setting .Text := ''; but it doesn't work even if I set it to '1'; it doesn't display a 1 only the previous value. The whole text line seems to be higlighted rather than just the text. Any ideas?, , Thanks, Mully

Posted to MB Topic: Delphi VCL « Delphi Board

Hello- Very much a beginner at Access here.  I'm trying to create a form for data entry, and may have several questions, but let's start with this one: I am entering data related to employee attendance at professional development sessions.  There are six categories of sessions, and each category contains about 20-40 independent sessions. For the first two steps of the data entry process, I would like to have two combo boxes: one in which the category is selected, and the second in which the exact session in question  (sorted by data and course title) is selected.  Of course, I would rather not have the second combo box contain over 200 sessions.  The question is thus: How do I make the contents of the second combo box dependent on those of the first, so that if a particular category is selected in the first, only the sessions in that category are displayed in the second? Thanks in advance.,

Posted to MB Topic: MS Access Interactive « Access Board

{Too Long!}

Posted to MB Topic: Delphi Internet Solutions « Delphi Board

I am trying to create a combo box that diplays the names listed in a table but I want he list filtered by a date field, that is in the same record, being < todays date. Some of the date fields will be blank and I still want them to be displayed. , Any help I could get on how to do this would be greatly appreciated.

Posted to MB Topic: MS Access Interactive « Access Board