Search results

Hi, I've have seen an access database in which a field/box ask's for the number of individuals required for an event. The User, through either a list/combo box or direct entry, enters the number. As soon as user tabs out of box, a subform appears with the same number of empty lines ready...

Shane, Thanks for the tip. I found that option by doing a search, but was hoping there was a way via an input mask. I used your suggestion. Same goal...different route. why fight it.

Hi, Is there a way to use the input mask to capitalize the first letter of text typed into a text box? I've used >L<????????? and it works as long as I enter enough letters to fill all of the question marks. I get an error message if I use less. I'm looking to capitalize the first letter...

Boblarson, Thanks for the help. I tried your suggestions and they still didn't work. So when all else fails....start over from scratch. With new forms/subforms everything is now working. I went with the linkchild/linkmaster method. Again , thanks for the quick response and the helpful...

Hi, I am having trouble trying to get a subform to show a record selected from listbox on the main form. Using the list box, when I click on the desired info, I can get a seperate form (InstructorList) to open and show the complete record using the following code: In the listbox...

Boblarson and Wazz, Thanks for the tips. I went with Boblarson's approach and it works fine. Thanks for the help and quick response Hawg1:) :) :)

Hi, Haven't used the 'ondirty' property before and am having trouble with it. I have a main form (PersAction) with a subform (PersAction_PersData). After Insert button is click, subform appears ready for new data. click save works great. I wish to have an undo button on the main form...

dcmaloney, Thanks for the advice and the shortcut to the other thread. At first it didn't work. So I created another DB from and started from scratch again. That time it did work. After carefull scrutiny of the form properties, I discovered that I had the 'DataEntry' field toggled to...

I tried that also. still just a blank form. I just don't know what is wrong. It's opening the right form, just not going tothe right record.

I have the boundcolumn set to 0. I think it is right since the first field in the table is PersDataID type autonumber. It still isn't showing the record, just a blank form

Hi, Need help on a list box issue. Solution is probably real simple, just can't see it with my bleary eyes. I have a form (INSTLKP) with only a list box (List6) based on a table ((tblPersData) with fields PersdataID; SSN; Last; First; MI) on it. When I open the form up, the listbox does...