Recent content by MossC

Mike, Although I'm sure there are many other ways of doing it, one way I have done this in the past is to open a new form based on a query of the table. For the criteria put [Forms]![OriginalForm]![goto1]. This query will have just this one record so there will be none to scroll to. This is...

Steve's code didn't work for me but jamescen's did. Thank you!! You are a star!

I've been out all day and haven't had a chance to check all day. I haven't looked at the code yet but I wanted to respond to Jim. These loan numbers are generated by a Bank and we will be servicing any loans in default. Thus, when the Bank gives us a loan to service, we have to enter it into...

Is there any way to do this without renaming either my field or my combo box? Is that even the problem? I am happy to leave a star for anyone who can help. :) Thank you.

This is where I am still getting stuck: If IsNull([LoanNumber]) Then MsgBox "You must enter a Loan Number" DoCmd.CancelEvent End If If DCount("[LoanNumber]", "tblLoanInfo", "[LoanNumber] = '" & Me![LoanNumber] & "'") > 0 Then MsgBox...

Actually, I made a mistake earlier. It is a combo box that has a row source as the LoanNumber field in a table named tblLoanInfo. The "Limit to List" is set to "No" so that I can input a new Loan Number. I tried the code on the Before Update section but it didn't work. I...

I changed the code a little to match my field names and here is what I came up with: If IsNull([LoanNumber]) Then MsgBox "You must enter a Loan Number" DoCmd.CancelEvent End If If DCount("[LoanNumber]", "tblLoanInfo", "[LoanNumber] = '" & Me![LoanNumber]...

Steve, What I have is a combo box and 2 buttons. One button is "View Existing" and one is "Enter New". If the "Enter New" button is clicked, I want to make sure that it doesn't exist. The combo box is so that it can be dropped down and then the "View...

I think this is an easy one but I can't figure it out. I have a text box where I will enter a value. What I want to do is to check the value against an existing table when a button is clicked. If the value that is entered already exists on the table, I want a message box indicating the value...

I have another form set up like that for viewing the data but this one is for data entry. When I use the subforms, if there is no corresponding LoanNumber the subform is not visible. Is there a way around this?

As I stated earlier, I have one query that combines 7 different tables that I have on a form. On the form, I have a LoanNumber (I think I said FileNumber in the other thread) and then I have 7 tabs, each representing a table that was combined by the query. What I want to do is to enter the...

anasazii, Thanks for the response. This thread has a lot going on. I will start a new one called "Passing one value to multiple tabs" to eliminate confusion.

I, too, have a related problem. I have a form that has a FileNumber and then 7 tabs. I have the Record Source set as a query that combines 7 tables. What I want to do is pass that file number to each of the 7 tabs. As of right now, I have to manually input the FileNumber on each tab. I want...

I tried that but what I need to do is then enter a new comment for that new FileNo. There may be 10 previous comments for that FileNumber or there could be 0. When the code ran, it gave me an error "You can't go to the specified record." Thanks.

I am working with a form and when I click on a button, it opens a new form. The first form holds a bunch of comments and is a continuous form so if one file has 10 comments, all comments are seen. When the button is clicked, it opens a form to enter a new comment. What I want to do is to...