M
Mike
HI,
I have the form frmPayments bounded to tblBook which I
use to enter records into tblBook. the data or records
entered are the recipts we have given to our customers
for payments received. We also have two recipt books
that has different recipt numbers. I have used codes to
generate the recipt numbers, We enter the first recipt
number and the code increment it by one for the next
recipt. The numbers generated by this code gets saved
(only one number at all times) into a tblSeries. I have
created a query based on this tblSeries and made a combo
box on frmPayments to show recipt number and have it
saved into tblBook. My users have been complaning that
the down arrow of the combo box is tricking them and they
always click on it but they don't need to do this since
there is always one number there. I want to change that
combo box to a text box which doesn't have the arrow
(dropdown specific to combos) but since the frmPayments
is bounded to tblBook I get error on the text box.
I tried to make the query with both the tblSeries and
tblBook but no data shows in there. when I remove tblBook
from the query, it works fine.
Is there a way around this problem so that I only have a
text box showing the recipt number and not the combo box?
Thank you in advance for your help.
Mike
I have the form frmPayments bounded to tblBook which I
use to enter records into tblBook. the data or records
entered are the recipts we have given to our customers
for payments received. We also have two recipt books
that has different recipt numbers. I have used codes to
generate the recipt numbers, We enter the first recipt
number and the code increment it by one for the next
recipt. The numbers generated by this code gets saved
(only one number at all times) into a tblSeries. I have
created a query based on this tblSeries and made a combo
box on frmPayments to show recipt number and have it
saved into tblBook. My users have been complaning that
the down arrow of the combo box is tricking them and they
always click on it but they don't need to do this since
there is always one number there. I want to change that
combo box to a text box which doesn't have the arrow
(dropdown specific to combos) but since the frmPayments
is bounded to tblBook I get error on the text box.
I tried to make the query with both the tblSeries and
tblBook but no data shows in there. when I remove tblBook
from the query, it works fine.
Is there a way around this problem so that I only have a
text box showing the recipt number and not the combo box?
Thank you in advance for your help.
Mike