Recent content by eldarbs

bigggg Thanks !! bob. it was realy helpful. the right syntax is : [MySubformControlName].Form.[MyControl] and for me code is this one : Me.Product_ID.RowSource = "SELECT Products.ID, Products.[Product Name]FROM [Products Category]INNER JOIN Products ON [Products Category].[Product Category...

i'm traying to find the right query syntax for a subfrom i have an "orders" main form and "order details subform" - as a Continuous frorm, in that subform i have 3 combo box that i succeeded to make a good working filtering of one on the others by puting this code on the enter event and the exit...

wow, bad news.. can you give me an example for a syntax if i will dicide to use asingle form.. that way also i can at least understand the logical of the query.. and mabye a can Continuefrom from that ?

I have a form with the fields - Category ID Product ID supplier ID. like in the image i attached. I want to create a query condition that make filtering - once I choosed one of the option in the categories id combobox then in the produacts ID selection box will show selection that only...

Thank's for the replies.. First of all because we have an example of such an action other software.. in that way you can also add as many items tou need for the order an if i will put let's say ten rows it will limmit it for ten items... I know about the option with use a subform with the...

it's mean that it possible? What do you mean you can do this only in continuous form ? And where I need to create dummy records ? What is the source of the basic registration ? Can you give an example for a code taht adding these records ??

creat a button that add a new rows of controls in a form I have an example for a form that I want to create , i'ts a order products form's I want to create a button that every time I clicked on it, it wiill add/create a lines of controls in the form like I showed in the example I brought up

its give me an error - #Name? I have one form that I linked to two tables by a query, one table for customers and another table for sales. the Form has one tab for filling customer data and another tab to fill sales data Both tables have a field called "Social Security Number" which I want to...

I want to create a text box on a form that will update two different fields from different tables simultaneously how ? Namely, How can I set the controlsource on the Properties of the textbox for two different fields ??