<br>
Hi Every one,<br>
I am using two tables.In Table1 i am entering project number and in table2 i am entering outgoing document details for each project. ie 1 to many relationships. I had given data type text for project no. in both tables. I have designed the program in such a way that when the user selects the project number on main form using a combo box a new form opens displaying the project details with a subform where the user has to enter the details in the subform. My problem is when i enter an integer value as project number everthing works correctly. If i use an alphanumeric or any special characters in the project number i am getting the error data type mismatch and as a result i can't open the form and subform where the user has to enter data.<br>
Any suggestions or solutions are appreciated.<br>
Thanks a lot in advance<br>
Charley
Hi Every one,<br>
I am using two tables.In Table1 i am entering project number and in table2 i am entering outgoing document details for each project. ie 1 to many relationships. I had given data type text for project no. in both tables. I have designed the program in such a way that when the user selects the project number on main form using a combo box a new form opens displaying the project details with a subform where the user has to enter the details in the subform. My problem is when i enter an integer value as project number everthing works correctly. If i use an alphanumeric or any special characters in the project number i am getting the error data type mismatch and as a result i can't open the form and subform where the user has to enter data.<br>
Any suggestions or solutions are appreciated.<br>
Thanks a lot in advance<br>
Charley
