Search results

Using the Navigation Forms, is there a way to check which form you're currently on? Can't find anything on the subject.

Thanks Bob. That worked. Now my problem is, I'm using a Navigation form. If I'm not on that tab, it will say it can't find subfrmHome. Is there a way to check what tab I'm on? Something like If not on TabHome, don't do anything, Else if on TabHome, requery that list box. And have a...

So I have a combo box that pulls a list of people. On one form, I have their clients, which will update as I change the combo box. On another form, I have a list of their clients as well as information in a list box. I can see the record source update as it will change at the bottom...

Sorry, should've said "That's the code that's in there now." It's the first line of that post.

Forms!frmMainMenu!subfrmHome.Controls!lstNetWorth.RowSource Here's the code that is in there now. Here's what happens: When I first open the program, the Home tab is what is displayed. If I change the combo box in the header of frmMainMenu, it will work. If I try put code that tries to...

Is there way from the design view to see a forms "path"? As in, when I'm trying to reference something and I say Forms!frmThis.subfrmThat. and so on, is there a way to see what something on that form or subform's path would be?

Okay so here's what I've been trying. Me!subfrmTab2.Form.cboSecondCBO.RowSource = "" and Forms.frmMainMenu.subfrmTab2.Form.cboSecondCBO.RowSource = "" Any of these I try to do I get the error that it can't find the field subfrmTab2. It will work on the first subfrm though, tab index 0.

I'm currently working on a problem similar to this. What exactly did you do to fix your problem? I can't seem to access anything except the first form as you stated. I have frmMainMenu (the navigation form) and several tabs. The only one I can access from my MainMenu is subfrmHome. For any...

Maybe this is better suited to the Queries section. Okay, so I have a navigation form called MainMenu. MainMenu has a header with log in information of who's logged in an also a combo box. I have several tabs on the Navigation Form, one of which has a combo box that will refer to the selected...

Okay, so I have a navigation form called MainMenu. MainMenu has a header with log in information of who's logged in an also a combo box. I have several tabs on the Navigation Form, one of which has a combo box that will refer to the selected option in the combo box on the header of MainMenu...

Okay, so at the moment I have a combo box that queries all the advisors for a certain company. After that updates, I want to run a query on the clients table to populate only the clients of that advisor but I'm having trouble linking the two. The Contact (advisors) table has a ContactID...

Thanks again everyone. That worked. I did what pbaldy pointed out.

Thanks for the replies everyone.

Here's the code I have: Dim FullName As String Dim Initials As String Dim UserName As String Dim Email As String Dim ContactFileAs As String Dim SplitName() As String Dim InsertAdvisor As String Dim FirstName As String Dim LastName As String Dim db As...

Question: Access Form/Database to the iPad I apologize if this is addressed somewhere else but Google, Bing ect. searches have yet to yield anything informative on the subject other than the Access app that only allows you to look at the database and Remote Desktop Connections. Any who, we...