I want to have an AVI to open in windows media player in a form. I have gotten this to work, but I was wondering if there was a way to make it so that the...

I'm trying to set up a multiselect listbox for a query parameter. I found a reference to http://www.mvps.org/access/forms/frm0007.htm for code to accomplish...

Sorry! I hit the wrong key. I have a form with 5 controls bound to a table. One control is the PK(autonumber). Two controls are required in the table...

-- Thanks for your help! Walter

I have a search form with 2 combos and 1 list box. Combo 1's rowsource is a value list. Combo2's rowsource is a query based on combo1's selection. The...

I have a user input form which opens in in dialog mode in the AfterUpdate event of a control. The user's selection sets the value of an option field and the...

I have code in the AfterUpdate event of a control with an error handler. when I update the control, I get a "compile error: label not defined". The Private...

I have a main form with 4 controls and a subform. When I try to enter a new record and get to control 4 the focus will not leave. It should move to...

I have several forms to enter service records on equipment. The main form(frmAddServiceDetails) has the date, equip. #, and odometer as controls to add data...

I have a db for a church with the tables: tblMembers; MemberID, FirstName, LastName, Etc. trelComMbr; ComMbrID, CommitteeID, MemberID, Date tlkpCommittees; ...

I need someone to verify my understanding of referential integrity. I have a form based on a table with two FK's relating it to two other tables. There will...

I saw in a previous post that a form that shows blank in form view is because it is not setup to allow data entry and based on a table or query with no...

I have a subform with 7 controls in form view on the main form. I want 4 of these to be hidden in a new record and the appropriate ones to be visible based on...

This another question related to a previous post by RickB earlier. How do you include the control's label in the hide/show process indicated? I understand how...

Is there an easy way to copy the current record to the "new" record (except for a key field such as AutoNumber) so a user can start with fields pre filled on...

This has got to be the easiest thing to do in a database, but I just cannot figure it out. I have a multi user database. It has "startclock" and...

I need to return to a sub siwitchboard from my forms, rather than go all the way back to the main switchboard. I'm tring to use a command button to do this,...

Using Access 2000, I can't prevent editing of data without locking each control individually. The form properties have no apparent control. Also, how can I...

How do you display multiple columns in a combo box and use only one of the columns as the control source for a field in a table?

How do you display multiple columns in a combo box and use only one column as the control source in a table field?