Chaning a combo to a text box on a bounded form-help please

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 recipipt books
that has different recipt numbers. I have used codes to
generate the recipt numbers, We enter the forst 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.

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.

A second question? I also have a list box on frmPayments
that shows records after entered, is ther a way to have
it show the last recors entered first and not at the
bottom of all records that have been entered? I tried
sorting but unsuccessful!

Thanks again.

Regards,

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top