Recent content by BJF

Thanks so much CJ! I will change the filed name to text as well

I should also note that the properties box does not work when i set the decimal value to 3 decimal places. The properties box does not affect my calculated number at all no matter what i set it to.

Hello, I am having trouble getting the correct syntax to format a query field that is a calculation. Please help! This is my expression in my query field: the name of the field is 48 and the calculation is working correctly for me however there are like 10 decimal places and I want only 3...

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