Recent content by JSRhone

In a form I have a List Box from a query named Countries and the fields from the query also. I would like to be able to double click on a country’s name in the List Box and have the related fields appear for that record. Can anyone help me with the VBA for this. Thanks Joanne

Thanks Rich works fine. Joanne

I made a query with several columns. The first is named sate. It has [Enter state:] in the critera box and sorted in ascending order. The sencond column has city which is sorted in ascending order. The third column is phone number which is sorted in ascending order. When I create a report...

Today I tried to put my text boxes on a new form and this is the error I got; Microsoft Access can't create any more conteols on this form or report. If you have deleted controls from this form or report in the past, you may be able to rename the form or report and then add more controls to it...

Option Compare Database Private Function PreviewQuery() 'Open the selected query in the Print Preview window DoCmd.OpenQuery [QueryList Control], acViewPreview End Function Private Function DisplayQuery() 'Open the selected query in Datasheet View DoCmd.OpenQuery [QueryList...

I was in design view and should have been on the right tab. I had done 5 perfectly before.

I am trying to make a form with a lot of text boxes. I was using 8 tab controls with several text boxes on each. When I went into preview mode the form was blank. While in design view the tab form when I got to tab 6 and when I slected any text box to move it the text box on tab 5 would move...

After puting up the chart go, select it and go to properties. Under properties ALL click on Row Sorce and to the right find the ... and put the text in the appropate field title Ex. This is the ledge: use the colon and then a space before the field name. Joanne I would like to know how to...