Hi everyone,
Im sorry if this is in the wrong thread but i have recently changed my backend to MySQL and kept the front end with access. I have transfered all the information from my tables to mysql and rejoined all the links in my relationships. I then tested each form one by one to make sure everything worked. All the forms bar one worked. On the form is a combobox called room numbers, it has a control source called "room_number" and row source with an sql statement which brings up all the room numbers in it. When a user clicks on an option from the combobox it populates all the textboxes on the form with the relevant information regarding the room number.
Now all this worked perfectly when i had ms access as the back end but once i switched over to mysql it stopped working. When i click on the combobox is shows me all the options but wont let me click on any of them?? can someone tell me if they have had this kind of problem when switching over or any advice on how to tackle this would be great.
Im sorry if this is in the wrong thread but i have recently changed my backend to MySQL and kept the front end with access. I have transfered all the information from my tables to mysql and rejoined all the links in my relationships. I then tested each form one by one to make sure everything worked. All the forms bar one worked. On the form is a combobox called room numbers, it has a control source called "room_number" and row source with an sql statement which brings up all the room numbers in it. When a user clicks on an option from the combobox it populates all the textboxes on the form with the relevant information regarding the room number.
Now all this worked perfectly when i had ms access as the back end but once i switched over to mysql it stopped working. When i click on the combobox is shows me all the options but wont let me click on any of them?? can someone tell me if they have had this kind of problem when switching over or any advice on how to tackle this would be great.
