Search results

everything works fine, the combobox searches records fine, and my new filter form by contact works fine. the problem is that if i use the filter by contact first it leaves the filter on. so if my user searches a contact when they open the form , gets info they need, then decides to move the...

i just tried it a nd found where it is located, thank you so much , now i know where to post to!!

DBguy - i tried your suggestion but i get the same thing, so the behavior is that after the form has a filter on, the combobox serach take twice to work, the first time it removes the filter, then if i select from it again it goes to the selected record. How can i make this happen in one move...

thanks DBguy - i havent been on the site in a while and i dont see how to get to the different sections anymore - used to be a list on the right side for macros, forms,tables, etc. where is that?

Hello everyone, I don't understand why this happens - please help! I have a form to look up customer info. The form has a combo box where i can select a customer and it take me to the record via vba, something like this Me.FilterOn = False Me.RecordsetClone.FindFirst "[acct] = " &...

Thanks for the replies, i ended up simply putting the code on the on current event that arnelgp recommended. Thank you

Hello, I cant seem to figure how to reference a subform field in a macro on my main form. I use the macro on a listbox so when a record is chosen, it locks certain fields. The macro is working fine to lock main form fields but when I add an action referencing my subform field, I get the error...

Hello, Its been awhile and i cant figure how to do this: I have a listbox on my form that shows company name [company], and theres a macro on the click to go to whichever record is slected from the listbox. The query for the listbox is 2 fields: [ACCT] and [COMPANY] [ACCT] is the primary...

Thanks for the responses everyone. I still have not gotten this to work. I will have to look into it further.

Hello, I’m having a problem when I put the following code on a DblClick event of a form that I open from my sales order form which organizes info for me: DoCmd.OpenForm "frmSalesOrders", acNormal, , "[SO]=" & Me![SO] It opens the form (actually the form is never closed because i am coming...

I am looking to have a total field (which contains an amount in every record) = whatever amount each record has.....unless another field in the query is populated...and if that is the case, then i want my total field to equal 0.

Hi, Up to this point i have used more VBA then exploring the power of queries, but I could really use some help with something that I think is possible but can not figure out. If I have a query that has 2 fields, and i want to make one field = 0 if the other field is true, how do i go about...

here is my row source for my listbox - at this point it contains all records instead of a filtered set pertaining to the parent record (Acct) that i am on. The listbox also has a macro that filters the subform of the main form and works fine but id like to narrow the contents of the listbox...

Thanks for the response Pbaldy, I unfortunately wrote the post just before walking out of the office this afternoon and will return on Monday and will post the syntax in the morning on Monday! Thanks again and look forward to your assistance. Sincerely, BJF

Hi, I am having a problem referencing a field in order to filter my listbox. I'm been driving myself crazy with possible solutions and nothing works yet. Please assist if you can and i will do my best to be articulate in what i need and currenty have.... TO start, This is a form with a tab...

Thank you both June7 and Micron! Finally got it between both of your help and input. I really appreciate it

I dont know why, maybe because i have the word standard in quotes before it???? my code was: =Format([Forms]![frmSalesOrders]![fsubProductNew].[Form]![QtyYardsOrdered],"Standard",0) & " Yds" and i get 30,000.00 Yds if i swap out the 0 with "#,#" i get #type! and if i just put #,#...

Thanks for the response Micron but unfortunately that wont work, however i can live with the decimal places. Thanks for everyones input

Thanks for the response, I forgot it turns it into a text string! i was able to use format function before the number portion of my control source and it worked however i cant seem to control the decimal places. my control source is now...

Hi, I'm having a weird format problem. I have a text box on a form that I use to display a number from a subform. I use it because its on another tab of the form. It works fine but the format only works under one condition. The control source is...