Recent content by BlindEagle4283

Thanks for the advice, but I would still like to know how i can get the values from a query within a form in order use them in other places.

I have a form that will run a query based on order number and it will find the order info, now i want to augment it so that it will take the customer from that query and run another query for all orders made to that customer. The problem i am having is with retrieving the data i want from the...

I have a form that will run a query based on order number and it will find the order info, now i want to augment it so that it will take the customer from that query and run another query for all orders made to that customer. The problem i am having is with retrieving the data i want from the...

any help would be greatly appreciated!

Thanks that makes a lot of sense. However, Due to the nature of how we do things; it makes more sense to archive the orders as they are completed (since the archive is actually the key component for this project), and that leads to my other issue. As these orders are filled documents are...

So I have 2 tables, the first is for "open" orders (where entries get edited changed and deleted), and the Second is for "finished" orders (where once an order is completed it should move from the open orders table to the finshed one where it will no change and will remain for futre reference)...

I could do that, but i wanted to see if i could set it in the form so that i could change the required field w/out changing the database

I am trying to make a form that will append when you click on the button I have made, but i want to make it so that the form wont let you append the table until you have filled a few "Required" fields. I am new to VB and am pretty much clueless, please help!