Recent content by heinc1

Wow! Works like a charm. Thanks so much!

Hello! I am also a novice and found this thread. I completely follow what you are suggesting, pbaldy, and want the price to be part of the sales record, but do not know how exactly to do it. My sales database is quite simple. I have a tblPriceChart that lists 8 items and their...

Ok! I got it to work. Here is how it is set up. I created an independent Macro named "Open Form". Form Name: Entry Form Where Condition =[Residents Table]![ID]=[Forms]![Residents Table Form]![ID] On Design View of [Residents Table Form] On Dbl Click Right clicked on the Elipsis and chose...

I just tried this and now the Where Condition =[Residents Table]![ID]=[ID] The [Entry Form] opens to the very first record as the [Residents Table] is sorted (by the field LastName) So, we have gotten past it opening to the new record, but it still is not matching the ID when the Entry Form...

I think you you are asking if I have a macro in "On Load" that would be telling the [Entry Form] to open to a new record. The answer is no, there is none.

Thanks for your speedy reply Trevor! I appreciate your willingness to help! I just tried the following: Where Condition=[Tables]![Residents Table]![ID]=[Forms]![ENTRYFORM]![ID] The result is an Enter Parameter Value dialog box opens saying Tables!Residents Table!ID. If I enter nothing in the...

I have a similar problem and found this post, but do not know how to set this condition to look at the source table I have a table [Residents Table] and a form [Residents Table Form] which is based on the Residents Table, but just contains a few of the fields . I would like to use the Residents...