Problems with MS-ACCess

[jathayer]

I have just started to play around with Access in the last few days and have found a few stumbling blocks; could you help.

Question 1:

I am designing a form that has two list boxes that are dependent on each other. For example the 2nd list box is dependent on the value of the first. When I select the first text box and select a value that value is displayed, when I then go to the second text box the list generated by the SQL statement is correct.

I then change the value of the first text box and the same values still appear in the 2nd text box, even after I select them.

How to I force the SELECT statement to be actioned on a change to the first text box?

Question 2:

I created a form using the Form Wizard and the form comes up blank. I have to select "Filter By Forms" to actually display the fields on the forms. I had created other forms without having to do this.

How can I make this form appear directly.

Question 3:

I have created a combi-box and when I select it I get a drop down list of items. However when I select an item from the list only the first field is displayed in the actual text box.

How can I display all the fields within the text box?

 

[Jack Cowley]

1. Add

Me.ListBox2Name.Requery

to the end of your code in List box 1's After Update event.

2. Hmm. Try making another form.

3. Combo boxes only shows a single column after you make a selection. You will have to concatenate the fields if you want to show all of them.

hth,
Jack