Recent content by lfazenbaker

I have a form where a user enters a bunch of client info into a database. I also have a form that I want to use if a user wants to view the table. What control do I use to display the data? I want it to be in tabular form so they can browse the list. Thanks! :confused:

Thanks, Scott! Worked Great!! :)

Pass to another form The first form is the first half of an application. The second form is the second half. When the user clicks "next" on the first form, a new record is added and the second form is opened. When the user completes the info on the second form, I want to update the record that...

Can someone please tell me what I'm doing wrong here. I have just added a record to a table. I would now like to get the record number (FamilyID), which as an AutoNumber field, and pass it to another form. My query is giving me an error that says, "A RunSQL action requires an argument...

I am trying to update a record using textbox values. Why won't this work? DoCmd.RunSQL "UPDATE Families SET & _ "[Reason] = '" & txtReason.Value & _ "', [RentAmt] = '" & txtRent.Value & _ "', [Utilities] = '" & txtUtilities.Value & _ "', [PantSize] = '" &...

Recordset Open Problem resolved Nevermind. I figured it out. For anyone who's having a similar problem, this is the solution. I had to change the SQL statement. Instead of a whole statement, I just needed to put the name of the table inside the quotes. Thanks.

Someone please tell me what is wrong with this code? (I have already defined db_file earlier in the sub.) ' Open a connection. Set conn = New ADODB.Connection conn.ConnectionString = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & db_file & ";" & _ "Persist Security Info=False"...