Existing Form Needs to have a few things added but I don't know ho

P

psquillace

Hello All:
I have a form which is basically just a recipt printer for orders
taken at a book show. I built it this was basically because 1) that was all
that was asked of me and 2) I do not know access all that well. I did not
plan them coming to me and asking for more 2 weeks before the show to add
more.

1st) I have a form with a drop down of all the customers in it that lets you
select a customer and it autofills the rest of the bill to name and such. I
need a text box entry that will auto generate a number. I tried to make a
OrderNumber Table and just pop in a text box but it will not make one. Is it
too later for that?

2nd) The order needs to be saved for future look up. Is this done with
Reports. I already have a print button that just allows the person to print
the order but that is it.

Any help on this would be much apprciated.

Paul
--
 
P

prspiderman

Hello Paul:
1) For the first part, creating a box that will auto generate a number,
well you could go back to your table, open it in design view and add a field,
this field Data Type needs to be "AutoNumber", that will generate a new
number with each new entry.

2) If you are just trying to view one particular order, not many orders for
the same costumer your form shold be sufficient. Now, if later you want to do
reports based on more than one order, build a query which have all the fields
that you want on report and then build a report based on your query that way
you just change the criteria in the query and your report will update
automatically.

Thanks
 
P

psquillace

Thanks Rafy,
I made a seperate table with just one item and called it
order# and set it to auto as you said but on my form in the text box it shows
nothing, Also, My form does not move up in incriments. What I mean is the
numbers at the bottom of the form that has the << >> does not move up when I
push it. Did I make my form wrong.

thanks again for your help in this,
 
Top