Search results

But yes, I want to filter the combo box in form 1 based on the selected value in the combo box in form 2? Can you help with this?

Hi vbaInet, Thanks for replying... Yes I think that is what I want to do. (Form2 is not a subform of form1, the mainform, as incorrectly mentioned in my first post.). Form1, the main form called Frm_Country, with PK called Country_ID, has a an unbound drop down combo box which determines the...

Hi Please help! I want to requery form1 from the afterupdate event of form2, but using the combobox value in the form2, as the form1 combobox value. In form2, I enter opportunity name in a text box and country selected in a combobox dropdown. The country selected in the combobox of form2 is...

Re: Openform method to open form & its bound subform on specific record in another fo Let me try again… I have tables with their PK’s: TblMeetings (MeetingsID) TblTopics (TopID) TblActions (ActioNID) TblActionOwners in successive one-to-many relationships. I have created a form of...

Openform method to open form & its bound subform on specific record in another form Hi - All went well, I successfully can launch a 1st form from another 2nd form using a macro containing openform method attached the 'on current' event of the 2nd form. So clicking on a record in the 2nd form...

Simultaneous form view & datasheet view Hi, Hope you can help.... My problem revolves largely around ergonomics, where records are displayed in form view, but the user also needs to see a datasheet view or "list" of all the records, not just the selected record. So, form view on the left...

Jal Your hierarchy breakdown with the 'Hershey bars' etc. was spot-on. Up to the point where you said 'what's the problem?', there was no problem. The problem came after where for example, I could not type Hershey bars or other products into the code everytime I change product in order Detail...

Thanks Jal, I have made some progress but still not quite there. As you recommended I have mastered the Immediate tool, I have plugged values into the DLookup criteria etc. All seems to work fine. Thanks! But still don't not know how to get the criteria to choose the correct row value of...

Hi Not being an expert, I have taken Northwind's approach to Dlookup, which works fine for BLPEuPrice, see below. I have tried the same for a different field in another table (Tbl_ProdCat4) but it returns always the last row value for the field InvFactor from Tbl_ProdCat4. I have a few one to...

Noyone has replied to my question, but I may have found an answer.. I created an outer join to the Tbl_Constants with primary key ConstID in the query window. (No relationship in the table view.) In the parent table, set the default value to 1 for ConstID. Mike

I am trying to create a table of constants using Dlookup (VAT, ExchRate etc) My problem is in the query design window, when adding the Constants Table, The query does not allow me then to create any new records in the last row unless I create a some kind of relationships. What relationships are...

(Typing this via my mobile, so please excuse the shortness).. Thanks! Will try & get back to you. Question: What must the table relatonships be, and the query relationships? Currently I have no table relatIonship, when I add the table to the query, then the query does not allow new records to be...

My issue revolves around the simple requirement to have a table where I can store reusable values, like VAT, exchange rate etc and access these these constants from queries to calculate price, inclusive of VAT, for example. For some reason this seems complicated to me, cannot get this simple...

Thanks Guys! I think this solves the principal issue, one of principal rather than technical prowess. Cheers! Mike

Well thanks guys, I think Doc Man put the proverbial nail in the coffin of my problem, which is one of principal more than technical prowess. Now on to my next problem... Cheers! Mke;)

If I undestand you correctly, my desire to split a Product Table for purpose of convenience and not principal is the wrong way to go. I just thought it might be easier to work with different tables for different product groups? Although I am sure one can split the tables for convenience, but it...

How would I then modify Northwinds approach to the Order Detail form control box ProductID, where the Dlookup on the UnitPrice text box refers to only to the single Products table unitprice field?

Hi I have a Products table that I need to divide into multiple tables, eg. Speakers, cameras, amplifiers etc. Dividing the table is easy, but I need to know the basic approach and methods used when a using multiple tables like this. Currently with one table, the database works fine, but do not...