Recent content by csroberson

Thanks Duane, I actually have your example working with my code and it suits my needs. I don't fully understand the fine details or semantics of all the operations but I understand much more than I did last night. Your help was very useful. Too bad this thread is now so mis-named but...

Nevermind on the Northwind database. I just found reference to it on the microsoft site: http://support.microsoft.com/default.aspx?scid=kb;en-us;209576 I have Access 2000 but Office 2003 and somethings aren't installed in Access, including the sample Northwind db. This task has become more...

Duane, I really appreciate the time you are taking to help me on this problem. It's useful and educational. Right now I'm just using a very basic Access book, online help and what I can find on the web to help me. Can you recommend a good book (or set of books) for reference regarding Access...

Using a Google search for "continuous form" and "cascading combo" I found the following on Access Monster: Does these seem like a reasonable approach? If anyone can point me to some example code, that would be appreciated. Thanks, Chip

Sorry to keep replying to my own messages but I thought I should mention, if it isn't already obvious, that the form is (or its contents are) bound to a specific table. I use this form to input and review the data. Roger Carlson's examples all seem to be for unbound forms/fields. Regards, Chip

Duanne, I appreciate you taking the time to respond to my questions. I have to admit that I'm struggling a bit to fully understand your message. To restate my situation, I basically have to figure out the following: 1) When I cycle to an existing record, I want to show the stored value for...

Argh, this is turning out harder than I thought. As I scroll through records, the displayed ConfigID field keeps getting set to NULL or it remains the same value as the last displayed ConfigID. I'm obviously going to need more work. Hmmm. Thanks, Chip

Thanks Duane, That helped. I had already found the forms reference for the current data but your reference helped me find the "after update" event procedure: Private Sub Track_ID_AfterUpdate() Me!ConfigID = Null Me!ConfigID.Requery End Sub However, I had to set the "Required"...

Please forgive me if this question is misplaced or malformed but this is my first foray into MS Access and SQL and I haven't done anything with relational databases since about 1985. OK, with that caveat out of the way, please allow me to ask my question: I am working on a SQL query for a Row...