Same values in table.

[Frodo]

I have a form where the user can enter information or he can browse for previous entered information.

The information entered goes into a table, there are two colums in the table one to store the inforamtion entered by the user and another "browse" that stores the same information but can not have duplicates.

So the user can choose from the form to write in new information og browse for previous entered information.

I tried to set the control source for the form both for the "entered information" and for the "browse" to the same table column and setting the "browse" to no duplicates but not working.....

Is this something I do in the table i.e. as soon as information entered appear in another column and has no duplicates..

regards
Frodo

 

[neileg]

I simply don't understand what you are wanting. How can you have the same information in two columns but only one set to no duplicates? Why do you want the same information in two columns?