Search results

Hi, I've a search form that lets the user search in the Orders. It consists of some combo and text boxes and a SubFrm (whose the record source is a query). The SubFrm is a continuous form. I've added a button to appear in each record (order). This button opens another form that contains all the...

Hi, I've a form used to add new orders (from the OrdersTable) containing a subform for order details, such as the item No, quantity, and unit price (from the OrderDetails table). I'm wondering if there is a way to check the current stock of an item while making the order to make sure that the...

Hi, I have a query based on two tables and I have a problem in editing records on it. -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Here is its SQL: SELECT...

Hi all, I've a from that contains a combo box and a subform. The combo box is used for searching in a certain table. In other words, after choosing a value from the combo box, I get all the records related to this value. This part is working very well. Now my question is: is there a way to open...

Hi, I have a form contaning a combo box and a subform. I'm using the combo box to search by the company name and in it's after update event I requery the subform. This part is working very well. My question is: how can I add an option called "all" in the begining of the combo box (that contain...