Hi,
I'm making a booking system and I have a form that allows you to select an existing customer from a combo box. The combo box uses a query to search for a name that is entered. So you double click on the customer that you would like to book the room for.
This opens another form that shows the roomno, arrivaldate, and departuredate from other forms that have been filled out. But custno comes out as #name?.
Now it all did work and I'm not exactly sure when it stopped working. It is still possible to make it word if the bound column of the combo box is changed but when you save and reopen, exactly the same problem occurs.
Can anyone help me cos I'm getting myself all annoyed!!
Thanks in advance
Emma
I'm making a booking system and I have a form that allows you to select an existing customer from a combo box. The combo box uses a query to search for a name that is entered. So you double click on the customer that you would like to book the room for.
This opens another form that shows the roomno, arrivaldate, and departuredate from other forms that have been filled out. But custno comes out as #name?.
Now it all did work and I'm not exactly sure when it stopped working. It is still possible to make it word if the bound column of the combo box is changed but when you save and reopen, exactly the same problem occurs.
Can anyone help me cos I'm getting myself all annoyed!!
Thanks in advance
Emma