Search results

thank you for the answer, it works well. The only thing is that i loose the possibility to search another society with the combo box when it is not a creation of a new member but it is better than the risk to have a society changed.

I have a table of societies and a table of the members from the societies. I have a form in which the user can create, see or modify one member of a society. In the head of my form i put some informations over the society (name, adress..) To make his research easier in all cases (create, modify...

Thanks for the answer, it works well.

After your DoCmd.OpenForm command in VB you can write : DoCmd.GoToRecord , , acNewRec

Thanks for the answer I can use it further, but in this particulary case I need the data to be in uppercase in my tables. If it's not possible, how can i require the user to entry the data in uppercase ?

First Excuse my english and i hope you can understand my access terms because i have a french version. May be you can based your form only on a table and create a buttton and in the event "on click" you can ask to open the new form with the command : DoCmd.Openform...

How can i transform the data entries by a user in lowercase to uppercase.