Search results

I take that back. I'm still getting the error. It only happens when I try to add a new entry, once I select the building and than move to another field to fill the next part in, that is when the error occurs.

I am actually working with a database that has entries in it but due to client confidentially I can't post the entries on here so I made a copy and deleted the entries. I changed the column count to 6 as you suggested and I no longer get the error but it also doesn't update any fields other...

Yes it worked with just the one code but once I entered the others I started getting an error and it didn't fill in the other fields. I attached the database for you to look at.

The error I get is: Microsoft Office Access can't find the object' .' If'' 'is a new macro or macro group, make sure you have saved it and that you have typed its name correctly. Does anyone know what would cause that?

Actually, for some reason it's not accepting that code. Here is what I entered: Private Sub Building_Name_AfterUpdate() Me.[Building Number] = Me.[Building Name].Column(1) Me.[Department Name] = Me.[Building Name].Column(2) Me.[Address] = Me.[Building Name].Column(3) Me.[Total S F] =...

Thanks for all your help!!

That worked for filling in one field. How do I get the other field to populate as well?

Ok, now I believe I'm in the right place but I entered the following: Private Sub Building_Name_AfterUpdate() Me.Building Number=Me.Building Name.Column(1) End Sub I got an error when I tried to use the form. It highlighted the first line so I guess something is wrong with what I entered there.

Btw, below is what I entered into the building number field which I'm not even sure was right. (Event Procedure) Private Sub cmdFind_Click() Me.Building Number=Me.Building Name.Column(1) End Sub Do I want the code on the field I want to autofill or on the field that I'm filling in to cause the...

Yes, I am clicking on the ellipses. Once I do that it brings up the Expression Builder which has (Event Procedure) where the text can be entered and than below the text box are 3 columns, one with folders, one with fields and one with commands(maybe?).

Is there any way you could look at the database I posted and see if you could suggest a code? The fields I want to Autofill off the Building Name are Building Number, Address, Department Name and Total S F. I'm trying variations of what you posted and what I have found on other sites but...

All that is in the Expression Builder when it opens is: (Event Procedure)

When I typed in [Event Procedure] I get the expression builder but it does not have these two lines Private Sub cmdFind_Click() End Sub Am I in the right place?

Here is my database with all the entries deleted. Fac_Drwgs is the main table. All the drop down tables are there just to create drop downs for easier data entry. The Building List is the table I want to autofill into the Fac_Drwgs table.

Thanks for the link but I'm not sure where to plug the formula into. I've seen references to After Update Event but can't find that any where. Is there any chance you could go into depth a little more. I'm still a newbie at creating drop-downs or anything more advanced in access. I've pretty...

Hi, I am currently working on a client database. This client has been having trouble entering data consistently the same. There is one table that has all of their drawing data and than I created a separate table which has all the building data. The building data is also in the drawing data...