Search results

Nice, glad you got it to work.

What do you mean by "used coil?" Does that mean the coil "Width" to be used when a specific "Gage" has been chosen? If so, you can have a combobox in the subform that is a list of "Gages" that when a specific "Gage" has been chosen, it will populate a bound textbox with the correct "width" of...

I typed "Calculated Fields" in the search button of the forum and found several threads that might help you. Anyway, I usually put calculated fields in a query of the subform's record source, then assign a textbox bound to that field. You can also put an unbound textbox in the subform which has...

Is there another unique identifier? Ideally a primary key and you could include that in the combo box query column? You can hide it then have the combox record source save that value instead of the two 1034. Ex. 1...1034...3 2...1034...5 The record source will save either 1 or 2, whichever...

I think you have to make 2 primary keys from Cust_Code and Bill_Date. You can have the two fields to be index (duplicates ok). This will allow duplicate values in Bill_Date and also Cust_Code, HOWEVER, it will not allow two records having the same Bill_Date and Cust_Code. Ex. Cust_Code...

I'm smiling right now. The code above is too advanced for me to understand and would probably take me more time than I would like to spend to incorporate it in my form. After spending a lot of time finding a way to do the same code on my database form, I finally did it! Well, not exactly, I...

Hi there, I have an existing thread Here. Unfortunately, I have not gone beyond my last post, and my problem seemed to have spilled over to some vba scripting which I'm totally at a lost. To make it short, I have a mainform and a subform. I have a DLookup function in my subform.combobox...

This is getting too complicated, I cannot seem to get it to work in my form... I guess to simplify the problem, how do I delete the records in the subform if the user changes a value in the mainform combo box? Update: Solved it! I think...

Hi again! Since maybe what I had in mind is also making you guys scratch your heads, there's probably a work around for my problem. I found an inspiration from deconstructing the northwind "Purchase Order" form. That is, to prevent the user from updating or even adding records to the subform...

There's a lot of "companies" in that post, I'm a little bit confused on how you want the companies to be filtered, is it by supplier, customers, products, etc. ? Just to give it a shot. What I usually do is base the combobox record source on a query then just choose the field you wanted to get...

Yes I did. Its not that the Me.SubformName.Requery function is not working, it's just not enough to re-run the DLookup procedure in my Subform.Combobox. In order for the Subform.Combobox to repopulate the textboxes based on the DLookup function, I have to choose the item again in the...

If we cannot refresh the repopulate procedure, how about refreshing or re-running the Subform.combobox DLookup procedure on Mainform.combobox update? Thanks.

Hi everyone! I have a combo box in a subform that AutoFills textboxes in the subform. The subform combo box also has a Dlookup procedure on "after update" event that has a criteria on what the AutoFill procedure will populate based on the mainform textboxes that is AutoFilled by a mainform...

Is the record source of FORM where the combo boxes are located only includes the Bases table? What I usually do is make a query that includes the main table and the one with the foreign key and add the fields that you require on the form then make that query the record source for the form with...

Hi MStef, "SubformB" is needed since my "SubformA" does not display all underlying items because I have a group of items that make up an item. "SubformB" displays all these underlying items and groups them together to get the total quantity added in "SubformA." What I would like to do is...

Hi everyone! This has stomped me. I have a mainform that has 2 subforms (Subform A and Subform B). "SubformA" lets the user add and delete records in datasheet view, while SubformB serves as a summary total of the records that have been added, and is locked. I have made an after update event...

Yes, I have indeed been going at it the wrong way :banghead:, I have just solved my own problem with some dizzying reads of other people's problems. It was hard finding such an easy solution since I'm not a good googler and really couldn't put in "search words" on what I was suppose to look...

Ok, I think I've been going at this in the wrong direaction. I think I just have to apply the discount from CustomerID to each OrderSellPrice... but I realized that I really have not done any database that includes discounts for each customer. The ones I did only have 1 price for every...

Hi there, I have attached a sample database that I made to help me explain my problem more clearly. I have a combo box query in my "fsubOrderDetail" subform that lists all products including their discounts. However, I would like that "combo box list" filter it's result by matching the...

How right you are... I was actually trying out if I could use the count function to hide rows of duplicates, but became too complicated for me. Very grateful for the inputs. ;)