Search results for query: *

Ok, Ginger, you have been a huge help! Thanks! I have it working... with the exception of the requery... in that I have to click a button twice for it to work. But I am fine with that! Thank you for all of your help!

... Where do I place this code? I am so new to this.

Ok, we are definatley getting somewhere. I have the CRS ID field in the Distribution form set to run the query when I update the field. It warns me that I am going to be updating some fields, but then nothing happens. When I go to the next record, it tells me that some "other user" has edited...

So is it like this.... Field: sourceField Table: sourceTable Update to: [SourceTableName]![FieldName] Criteria: ? or Field: destinationField Table: destinationTable UPdate to: [SourceTableName]![FieldName] Criteria: ?

Ok, so now, it appends the data to the table as separate rows. What I want it to do is to simply update the null fields in my destination database to the source databases data.

Alright: I went to Queries. Created a query in design view. Double clicked on Plan Data (my source). Clicked Close Field: [CRS ID Number:] Table: Plan Data Sort: *blank* Show: (checked) Criteria: [Forms]![Distribution Database]![CRS ID Number:] Saved as Query1 Went to Macros. Created an...

Thanks for not hitting me with a hammer over this. Can you be more specific on this process?

In the DISTRIBUTIONS table, there is client data. In PLAN DATA there is tax information. One department at my firm works with the client data -- the others work with the tax info held in PLAN DATA. So, can I type in a 3 digit code and have it find the matching entry in PLAN DATA and copy the...

Can you be more specific? I dont know much about this, as I am finding out.

Hey everyone, I am a complete lamen on this, I am finding. Here is what I want to do. I have an access database file with two tables inside it: Distributions AND Plan Data In both tables, I have the following fields: CRS ID Number: Plan Name: Company Name: Company Address 1: Company Address...