Search results

Great that works. Next How do I find a specific record and display only the fields that belong to it?

How do I access the data that is held within a recordset so that I can use it in various ...if... statemnents in an access database.?

Thanks v much that works great

Trying to merge a field on a form to a word document using .ActiveDocument.Bookmarks("fieldname").Select .Selection.Text = (CStr(Forms![frmMain]![subfrmMainCompetitor].Form![fieldname])) The field in question is a combo box and all that is being merged to the word doc is the bound column number...

Trying to merge a field on a form to a word document using .ActiveDocument.Bookmarks("fieldname").Select .Selection.Text = (CStr(Forms![frmMain]![subfrmMainCompetitor].Form![fieldname])) The field in question is a combo box and all that is being merged to the word doc is the bound column number...

To insert a user in a field use currentuser()

Problem solved thanks

I have a combo box which gets its data from a query. How can I populate other fields on the form based on the users selection in the combo box.?

You don't need to have local admin rights to change Access workgroup files.

Try changing it to system.mdw and see if it makes a difference. If not you can always rename it back

Just checking.. Is you workgroup file actually called "mywrkgrp.mdw". If it is then thats your problem. I think access will always look for a "system.mdw" Worth a try