Recent content by BJF

ok, let me double check this. Just to make sure, should the value be set to 0 (not blank but zero) since my 1st query column in the listbox is ACCT? I know that when referencing the first field it is Column(0). Thanks

Hi, The value is set to 1 , i guess by default, i didnt set that. Is that correct?

Hi DBguy, My listbox is unbound, is that a problem?

Hello, I have a form with Bill To customers with a tab control. I put a subform on a separate tab for Ship To's that pertain to the Bill To of the main form. It works fine, and there are multiple Ship To's for each bill to which i see and can scroll through the records fine. The problem im...

Hi DBguy, if this helps, the sql for the listbox is : SELECT tblStandardCost.ProductNum AS [Product#], tblStandardCost.Inactive AS Active, tblStandardCost.FinishedWideWidth AS W, tblStandardCost.Description FROM tblStandardCost WHERE (((tblStandardCost.Inactive)=False));

Hi DBguy, if this helps, the sql for the listbox is : SELECT tblStandardCost.ProductNum AS [Product#], tblStandardCost.Inactive AS Active, tblStandardCost.FinishedWideWidth AS W, tblStandardCost.Description FROM tblStandardCost WHERE (((tblStandardCost.Inactive)=False));

Hi, Thanks, but this didnt work, i really thought it would too, it made perfect sense to me but it made all fields invalid with type## errors I will keep trying at it.

Hi, Control source of listbox is blank, I added a listbox from design view and the wiazrd runs and i choose navigate to a record on my form. It auto sets up a macro to do such, The record source for my form is just the table: tblStandardCost

Hi, The code is in an embedded macro it uses a where condition: ="[ProductNum] = " & "'" & [Screen].[ActiveControl] & "'"

Not sure how to go about that?? My record source for the form is just tblStandardCost, no query just the table

Hi All, I have a form that contains a listbox which is used to select a product and the form navigates to the selected record. I also put 2 radio buttons on the form called Active and disactive. These buttons toggle what the listbox contains: here is the code for one of the buttons: Private...

Thanks very much for the response. I will go o we it again and see if I can work a query into it to achieve what I am looking for. Thanks, BJF

Hello, I'm having a problem getting the proper value from my calculated field in my table. Does anyone see the problem here? my calculated field is: StdCost = ([R1]*[R1Percentage])+([R2]*[R2Percentage])+([R3]*[R3Percentage]) R1, R2, and R3 are all lookup fields that look to another table and...

Thanks for this response Plog, I will have to think about this and make sense of it before i do anything else.

Hi, sorry if I didnt explain this clearly, Each Resin is a separate record ResinCode is the field name and some records are single resins, while others are blends made up of single resins within the table.