Recent content by chipperly

Ok, thank you. I have a relationship setup between both tables as the Account number. Just that the account number is blank in the note table because a note hasn't been created for the account yet. When I create a note, i want to populate the corresponding account # into the table. Should it...

Ok, thank you. I'm hoping not to have to re-design the whole form, but if I can't find a solution to this soon, then I'm going to get started. All I need to do is enter the account number from one table into another when a new note is created.

Hi, I'm new to access and am having a really tough time with this one task. :banghead: I have a query (QRY_full_data_census) that I use to populate a continuous form. The source of this query is two data tables (TBL_Census and TBL_Notes) which link together using an account_number. I can...