Search results

Follow up, plog's suggestion is correct and works, i had an additional error elsewhere in the query.

Not sure that i did that recommendation right, still was not filtering, but because i am still learning Access i will go with the simpler cbx for now. thanks again plog

One other thought i wanted to get your opinion on, what about a hidden text box that uses Left(,2) to grab the start of the cbx and then can the query run off the hidden text box? but then that puts me back to my initial question of the like syntex would be correct looking for a value in a control?

Thanks for the feedback guys, i guess the way of a drop down without limiting to list will have to be the best way to go. Do you recommend then just a Find/Replace in the table for the initial clean up?

Hi, I have a combo box in a navigation form that has a list of Vendors users enter in another table. I want to pull up all the records that are Like that cbx. For example one vendor might be Jiffy Lube, but users have entered by error, Jiff Lube or Jify Lube. Is there a way to get all the like...

just tried something and solved it. I needed to tell the lbxMP to go null and then me.ctrl.sourceobject = null. I thought i was close when i posted this, hope it can help someone in the future.

Hello, I have a listbox "lbxMP" that holds names of forms and a subform "ctrlMP" that opens selected form (ctrlMP.sourceobject = lbxMP). I also have some various master cbx that control criteria in each form. I am trying to create a button that will not only clear/null all the cbx values...

Perfect, thanks so much

Hi, I have a form with a cbx (Reportcbx) that list a series of forms, then i have a subform "Reportctrl" that loads the form from the Reportcbx. How do you prompt a msgbox of the user clicks run button before selecting a report from the Reportcbx, aka Reportcbx is null? I have currently: If...

I have seen post on how to double click an ID in a query an open up the form with that record, but i was looking at how to do that when the form is inside a subform. I have a form [Managers Log Nav] that has two subforms on it. the left is mlogentryctrl (which is a place a new record can be...

Update: I have the query working using [Forms]![frmMain_toplg]![SubForm1].[Form]![NavigationSubformTS].[Form]![Managers Log Query]![MLTScbx] I needed to reference another form. However, i really want to put on the form Managers Log Nav form a cbx "mlcbx" and a subform "mlctrl" where the...

Hello, I have a navigation form and one currently working query based on text boxes on a form buried in 2 levels of subform. [Forms]![frmMain_toplg]![Subform1].[Form]![NavigationSubform].[Form]![Trans Sup cbx rec] that works in one of my main navigation buttons. but then on another button i...

Thank you so much, works great!

I have a main form with txtUser that [fosUserName()] to get the current logged on user. The issue i have is our format on the network is first.last I also have a subform in the main form that runs off a combo box and will pull a custom form into the subform based on the user. I want to do away...

once again CJ a huge help and breaking it down so a novice can follow, works great!

I have a main form with a combobox with 12 different names of 12 different forms. I know how to open the forms based on the combo box, but is there a way to rather than have the form open in normal, dialog, etc. view that it can open in a subform that i placed in the main form? Practical...

I am not sure this is the underlying issue but the query ended up being right but the parameter box didnt go away until after i removed [frmMain_toplg] from being hidden...working correctly now

hello, I have searched for similar issues but cannot quite see my mistake. I have a frmMain_toplg which is my 1st and main navigation form then inside that is Subform1 then i have a button that takes me to Expense Navigation (which is a second navigation form. and inside that is...

Thanks everyone, i will give both of these methods a shot and see what i can do

Hello, I have an unusual situation I haven't seen and hope to get some help on. I have a form with tab set one tab called "Enter Receipt" and another that houses 2 queries called "Reconcile". My issue is when I open that form, I have an On Current Macro to go to NEW record for my Enter...