Can I have multiple default value's in a table based on data in another field?

I am trying to place a footer on a form which counts a subset of the records that the form displays based on one of its fields. The form uses a query to...

Hi I have a form which when a new record is added adds the field CustomerID Ref Number to 2 linked tables. Into fields CustomerID2 and CustomerID3 All...

I have a from field that I added to a form. All other fields in this form are linked to Table 1 (the form was created to fill Table 1) but this new field...

I'm trying to get to one form from another in an Access database but keep getting the message above. Can anyone please help me understand why? I'm using...

I remove and reinstalled access to see if I could get the field list and property icons in the ribbon bar to work. If I choose creat form - I see the form...

Problem: In Design or Layout view the "Add Existing Fields" and "Property Sheet" do not work in any data base new, old, practice. "In both – Create Form...

I have a form that is set to continuous. On the form are a bunch of questions under the last question there are some fields but I can't do data entry with...

I have a form which has a query made up of a few other queries (this may be an incorrect thing to d I've been going nuts trying to figure this out, so any...

I am creating a subform (Access 2003/NT) in which the user will type in a Melt# (contained in the tblChemicalResults). I need to create a side by side...

I creating a form that will need a field that will have a JV field that needs to increment when a new record is created. The field is 12 characters long with...

i have a form with three Option groups and one combo box and i am trying to filter it out to the subform that i have on the same form. here is the code,...

Hello, I am pretty new to Access 2003. I have linked several databases to one central database. It is used to track tools. When you request a tool from...

I have an Orders form. It contains fields tied to an Orders table for Invoice Number, Order Date, Line Total, and Supplier ID, and a subform Order Details...

I have a form that pops up when Access starts. There are no macros, sql, modals or modules attached; yet I can't stop the pop up. I made a copy of the...

Just developing an Access db with forms - have switched the autostart to open with the switchboard and must have selected not to see the tool bar ..So, I can;t...

I have an unbound ListBox and an unbound ComboBox on the same form. I have them both set up to display the values from the same field in the same table. The...

Hi All, I need to insert a new record with a GUID Primary Key into a table. Does anyone know how to create the new GUID in Access to pass it into the INSERT...

I am trying to figure out why the mouse button exhibits different behavior depending on the database. The first action happens when I create an asset...

I have created a ms access Db in 97. It has several pdf files linked to a form using hyperlinks. It works fine in my pc which has acrobat version 5. But when...