Replies

I am afraid that this got pushed to a back burner without resolution. My teammates decided to remove the field from the publications catalog and use a smaller [Document Summary] field of data type text instead. A cheap workaround, I’ll admit, but it worked.

aap2

We have Norton 2000 so this may be applicable. I will give it a try and see.
Thank you.
aap2

Ok, I have solved the problem. I did overlook the obvious. There was a macro called autoexec that opened the form with Data Mode set to “Read Only”. When Data Mode was changed to “Edit” it works fine.

Thanks all.
aap2

Charlotte,

I want to open up a form that displays a subset of records, one record at a time, based on filter criteria selected in a combo box on another form (this may change, see other post). I modified the syntax of my OpenForm statement as you indicated. Closed the code window and it works fine. I close the database and open it again and it does not work. The list drops down but I am unable to select an item from the list. Very wierd.

[CategoryControl] is a field in the underlying table where the records reside. It contains one numeric value (long integer) of 1 to 12.

So I say to myself, “Self”, I say, “am I overlooking the obvious?”
Any suggestions are most welcome.

Many thanks,
aap2

Thank you for the suggestion. I did have one form opening another. The users seem to think your idea will be an easier interface.

Still the same behavior after hard coding a category code. I am investigating the references as I seem to remember reading a post here that stated the ADO is the default data access model and if DAO and ADO references are checked then it leads to problems.

If all else fails, I will write the form in VB using ActiveX data objects to connect to the MS Access tables.

Thanks again.
aap2

Paul,
Many thanks but it still behaves the same way with your suggested code. I am beginning to think that there is a missing reference to my project in VB or something like that.
aap2.

How or where do I find out what type of account it is? Is my e-mail address is any indication?
If so, it is somename@msn.com. The MSN Explorer 6.0 Help does not indicate what type it is. It does have some information regarding the use of Outlook Express. I perfer to use Outlook as this is where my work for the last 3 years is set up.

The memo field, called [Description] is in the SELECT, the UNION SELECT, and the last UNION SELECT. The file is attached. The end result pulls records FROM three different queries based on the publication type. (ie. Category1, Category2, BestSeller)