Replies

Thanks for the recommendation; however I have limited their entries to the list. Therefore they can only enter valid values. I have set the after update property to set focus to the next field; but this VBA code will only activate after the tab or enter key have been depressed. I just want the tab to advance to the next field after the forth digit has been entered and the value is listed in the combo box list.

I will look at the Event Procedure in the After Update Control; to see why it ‘s not moving to next tab item.

Nope; I just looked again; I didn’t see it.

What if the field is a combo box; I want it to move to the next field when I depress the enter key; better stated how do you make the tab key and enter key function the same?

Worked perfectly; now that the combo box list drops down automatically; I would love to save space on my form by eliminating the arrow on the combo box; how can you turn this display off? Thanks very much. Should have used this method many years ago.

Thanks; this worked out fine; I took a look at it over the weekend and it works perfectly. Here my next question; can you changed the value of the subforms “Link child Fields” and the “Link Master Fields”; in the VBA Code based on if parameters?

Sorry; I thought that I had responded. I want to have one subform filter the values in another subform; when I click on the value a field in the first subform is in continuous format; I want the second subform to become visble and use the value in the first subform to filter the records displayed in the second subform in continuous format.

Do you have any examples using these Controls

Thanks; I like the idea of having the subtotals in the Form Footer; it’s the easy and quickest option. I will try this option and persuade my customers/users to accept this option. But, my customers/users are Accountants and they like their information displayed in spreadsheet/datasheet format; with the subtotals after each grouping.

Thanks again for your support and quick response.

Yes; using a report would be a snap. However, I like the info to be displayed in a form so the staff can update; as needed. I could create three subforms; but the record counts are never the same amounts.

I have a continuous form; that has three types of records; I would like to have a subtotal displayed at the end of each of the record types; I can only display a total at the end of the continuous form in the form footer.

I have use this code in an update query to change from Uppercase to Lowercase; but now I can’t find it. How would use this code.

How would I control the opening of a form based on a value with in a table? Or better stated if no records existed for the value of the command button the form should not open; however there are records wiithin the table.

Do you have any examples of using where condition? What if I wanted the form to only open up if certain values existed in Field A within TABLE A?

I just open the form, no where conditions?