I know this is easy, but how can I make a continuous form display only active records without a new record at the bottom? I would like the new record to be...

Hi, Let me start by saying I am a novice user. Can a form be used to update data in 3 separate tables? I have 3 tables: recommendation, accomplishment,...

I have two tables, Membership and Board, into which I want to enter data from one form. When I try to place a text box on this form with a control...

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?

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...

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,...

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...

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...

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...

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...

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 have a db for a church with the tables: tblMembers; MemberID, FirstName, LastName, Etc. trelComMbr; ComMbrID, CommitteeID, MemberID, Date tlkpCommittees; ...

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 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 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...