Search results

im sorry I misunderstood what you said. My tables do not have look up fields. So now imnot sure what to do. I thought you meant that you could not use dlookup with opening forms. I dont have conflicting data in form 1 and form 2. It is that right now two different forms can have the same ID...

I was using lookup fields, because that was the only way I could think of achieving my goal. The code I have finds what im looking for but has an error first. What are my other options? Basically I have a ID Value on form1 that the user inputs. This ID value (Suf) is stored in a table. The ID...

i tried it with the Me.combobox.column but I still got the same error(wrong data type in the expression of one of the arguments). I really have no idea how to debug this. It is very frustrating.

Does it matter is dsuf is a pull down box?

The docket no suffix is not numeric. It is a text field.

I tried stLinkCriteria = "[Docket No Suffix]='" & Suf & "'" but that didnt seem to work. I still got the same error. I also tried declaring the variables, but I still got the same error. Im not sure what else to check.

so i figured part of it out. I added DoCmd.GoToRecord , , , stLinkCriteria to the bottom under the DoCmd.OpenForm... Now it shows the correct form I want (it has the similar ID value), but I get an error which I am not sure how to debug. The error is Run-time 2498: "An expression you entered...

I displayed a message box after each and the message box does in fact appear and the same problem happens (all forms open). In addition, I think the code does go passed beep, because the message box "The docket number already exists" appears before the next form opens. I also tried declaring the...

I have two forms. They are both linked to different tables. In addition form 1 corresponds to form 2 through an ID value (text box). If the user inputs a ID value that already exists in form 1, I want the corresponding form 2 to open. Basically I want to open a specific form. I have written the...

I have a form with a certain ID number that the User enters. The ID number is 3 fields (2 text and 1 numeric). The two texts are pull down boxes. If the user enters an ID number that already exists, I have a message that says "This ID number Already exists." I have the code that searches for the...

I keep getting an error on my code. the error says, cant find the field " refered in your expression. Basically i am trying to compare 3 fields with the same fields in the All Data Table. The three fields are dpre, dsug, and dnum. The data table is All Data Table. If the 3 fields are the same as...

I dont think the form is a subform. They are two different forms. When I click a button that is when the second form opens. Is there a way I can set a value on the second form based on the value of the first form?

hey thanks alot. The link was helpful.

It is a subform, how would I include that in the path? What do you mean by if its definetely open?

I wrote If [Forms]![Invention Disclosure Input Form]![Status] = "DP Ready" Then [Forms]![Dockets Data Input Form].[Status] = "Ready" End If but it gives me an error saying that it cant find my DOckets Data Input Form. That is what the form is called. I am not quite sure what the problem is.

I have one form (called Sheet 1) that has a pull down box called status. On a second form (called Sheet 2), I also have a pull down box called status. However they have different values in the pull down box. If the user in form one selects "Ready, " and clicks submit, I want the form 2 status...

Thank you.

I have a form with a pull down box which has a list of about 50 names. The last names are capatilized and the first names have the first letter capitalized and the rest lower case. For example, SMITH, John DOE, Sam The user can input their own name if it is not included in the pull down...

The name field is all one field. The first and last name are entered in one text box and are seperated by a comma. Is there a way to capitalize the last name and lower case the first name if they are inputed in one text field and seperated by a comma? I appreciate the help.

I have a form with a pull down box which has a list of about 50 names. The last names are capatilized and the first names have the first letter capitalized and the rest lower case. For example, SMITH, John DOE, Sam The user can input their own name if it is not included in the pull down...