Recent content by MarkRind

I have created a form that inputs data into two tables. They are connected in a one to one relationship with both primary keys. Unfortunatly evertime I enter info on the form, the minute I enter info on the form for the child table, my data disapears at the beginning of the form. How can I...

See I new it was something I overlooked. Thanks

Right now, the form when opened, opens to the first record in the table. That is great if would like to see all the records in the table, however I now have to hit the little arrow with the star atthe bottom of the form to get to the edit part of the table. I hope the helps.

There has to be an easy way that I have overlooked, but I am wondering how to have a form go to the next open record once it is opened, so the data entry people do not have to click on the little arrows at the bottom of the screen. The less some of these peopel have to do, the better.

Thank you, that did it. ps I didn't need the ",0" when I used it in the query

Thanks for that, but how do I use that in a query, or do I ned to write code. I am not expert enough to do that. [This message has been edited by MarkRind (edited 04-19-2002).]

I have created a an invoice db. There are 4 separate departments that have to bill the customer. Not every department bills every customer, so sometimes I have "empty" fields in my querys. My totals will not appear unless every department looks at every invoice. Is there a way to total with...