Replies

Charlotte,

That is a solution. Thanks for verifying this Access 2K limitation.

–llyal

I am doing all that you suggested, the problem is the changing the control source and then having that new form sync up with data like the form it replaced did.

I realize that this problem is hard to simplify for a help forum.

Let me ask- changing the control source (meaning changing the form) of a subform control should be straight-forward, in respects to the form syncing its data? This answer to help me focus what I need to concentrate on as a problem.

Thanks!

–llyal

Sorry for the confusion. The two forms are subforms on a unbound main form; the ContactID subform is a continuous form, the Detail subform is a single form; the ContactID subform controls the Detail subform.

The two test forms I am using with the Details subform (by changing SourceObject) are frmDetailsSubPrimaryMain and frmDetailsSubSecondaryMain.

When I first open the main form, the frmDetailsSubPrimaryMain is the default form in the Details subform. It will update itself fine from the ContactID subform. When I programically change the Detail subform default form to frmDetailsSubSecondaryMain, I find that it will display the data of the first record in the ContactID subform and will not update itself, as I move through the ContactIDs. I have tried re-defining the Master, Child links, requery, and refresh, with no success.

In summary, changing the Detail subform Source Object does not give expected results.

I realize these descriptions are confusing, but i do not know how to simplify it at this time.

Thank you!

–llyal

The DateAdd might be the way to go if i want to subtract a specific time (hh:mm:ss); I do see alot of conditional loops being made for each time type (hh, mm, ss) to test if the subtraction causes a 24-hour rollover into the previous day or not, so that the date could be decremented;

-Thanks for the help!

–llyal

I just tried it with the Memo in place of LongText and it worked fine, too; no explanation;

thanks for the help!

–llyal

I apologize,

I would not do this if i had questions with Word or Excel; Because Access and VB are very alike, and posters do not consistently use certain newsgroups and/or post in a consistent manner, I concluded this was the best way to get my question addressed, as well as help others who will search the forums for answers in the future and do not realize that Access and VB overlap a lot;

Here is the correct answer;

I learned from another newsgroup that one needs to use the LONGTEXT with CREATE TABLE to make a memo field; Using MEMO (which is logical) gives errors;

Thank you for the help!
–llyal

The use of the MEMO in CREATE TABLE causes error; I have learned that one is to use LONGTEXT to create a memo field with CREATE TABLE; I wish i knew how the person who helped me found this information!

–llyal