Search results

Rich thanks for your reply...you see when a delivery comes in the user enters the details on a form which will then update the delivery table. Some products will require serial nos and some not. In cases where they need to put in the serial no., instead of having one entry with del.no, qty...

Is it possible to create text boxes depending on a value from another text box? Case: depending on the quantity entered, open up enough text boxes to enable the users to input serial numbers for each item delivered. eg: if quantity delivered is 3 I need 3 individual boxes on the form to allow...

Thanks fizzio for your reply... I have 5 coboboxes based on the same query 'cos my users find it a bit daunting to look at lots of details on the screen! so i give them the option of selecting records based on single combos (ie name or dept or order no)... Going to your 3rd qstn I am not doing...

Thanks Sean, u saved my day....the funny thing is that I have used unbound forms all along and done sql queries to get info on screen, but with this one it was as if I had no clue and made it into an unbound form. Wasted one whole day...thanks for your help. Farrah

Sean, did u manage to get to the bottom of this? I've just realized that my query under 'forms behaving badly' is the same as this. Mine is a simple form that displays order info and it updates the whole recordset available to the comboboxes with CustomerId of the last record displayed and it is...

Well I am also new to this..but can't u have an update query to increment the order number by 1 (on systable) each time u enter a new order?

This is supposed to be a simple form based on order details. Users can choose from 5 combobox values to get the order info on screen. Comboboxes are all based on one query. I then use the order no. to do a DoCmd filter to get the 'order header' info. The subform will then display all the...

ditto please Thanks Farrah

Pat and Glynch, thank u both for your responses. Yes in the end I did it in two stages, created the supplier orders with autonumbers and then used the supplier id + customer order number to form a supplier order. Again many thanks. Farrah

Thanks glynch for your reply. Yes I am using Autonumber for the supplier order number. The customers can place an order for more than one item. These items will then have to be ordered from outside suppliers. So for eg. customer places an order for five items, 3 of which will be orederable from...

A very happy New Year to you all. I have set up an append query to create supplier orders from orders placed by customers. This is sort of working but it is giving every order item a new supplier order no. So if x items have been ordered from supp A, x supplier orders are produced. And ideally...