Data Entry in SUBFORM

I have a database that each month I assign various tasks to multiple people. I am trying to auto fill some of the information from one table to a new record in another table. People: Hireid (primary key) name, supervisor, role etc. Assign: empid (primary key matches hireid) AssignMonth, supervisor week1assignment, week2assignment.
I am trying to make a subform that auto fills the empid (hireid from People table) in the subform so I don't have to fill out information I already have. The Assign table is empty. Is there a way to auto fill a table with the subform when there are no records in the subform table.and how if you can

Sponsored Links:

Related Topics

Tabbing from subform to subform when entering data
I have a form with 5 subforms. All 6 forms have essential data entry boxes. The tab stops work fine when jumping from the main form to the first subform. Not so when jumping from the first subform to the second subform.

When tabbing out of the last data entry text box on the first subform, how would one go about having the cursor jump to the initial tab stop on the second subform? Second to third and so forth


Subform not allowing further data entry
I have a pre-existing access form that I am trying to get working again.

It's fairly basic - the user selects the Contract No from the drop down menu and all of the resources and their allocated rates are displayed for that Contract in a subform. My issue is that the subform will not display an additional row to allow further data entry.


Open a form to a specific record including correct record in subform
I have a search form that displays a bunch of sales records in a subform based on sql. I also have a more button that will take you to the data entry form based on the id # in the search subform and the ID # in the data entry form.

The data entry form also has a subform that displays the sales details. There can be more than one sales record for a particular building. The problem I have is there a way to not only open the data entry form to the specific building record but also have the subform display the correct sale.

Currently the subform shows the first sale in the list.


Repaint method not working on the first entered record
I have a form that has a subform in it. The subform gets populated by a query. When you enter data into the form and click a button it is supposed to add it to the subform. It works partially right now. It is refreshing the subform, but it is one click too late.

Example if you enter entry 1 nothing happens when you enter entry 2 the subform then shows entry 1. The repaint sub routine is: Expand|Select|Wrap|Line Numbers

1) Private Sub UpdaterxQuery()
2) [Form_Log Form].rxQuery.Requery
3) [Form_Log Form].Repaint
4) End Sub


Data Entry Form/Subform Problem
I am having a problem with a data entry form. The form is for entering data from employee production logs. In the main form I want to capture the employee name, date, work arrival time and work departure time.

I then want to move to the subform to capture detail from the log. Each record in the main form may have multiple records in the subform. I added a command button on the main form to save the Main form record before moving to the subform.

Once data has been entered into the last field of the subform, the cursor moves to a new record on the subform, not back to the Main form. To enter data for another employee, the data entry operator must click on the first field of the Main form and enter a new user name date arrival, departure time.

The problem is that the subform will not allow entry in any of the fields. My query must be set up incorrectly. I have checked Allan Browne's website, on why a query might not updatebut can't find the problem.


Requery after data in entered in subform field
I have built a Customer/Invoices/Payments database that keeps track of company profit. I have a mainform with a single record subform to enter data into a table and another subform to view data from a query.

This subform entry will effect the data in the query once it is entered , so what I would like to do is enter the data, save and requery to have the other subform's query update with the new information before I close the mainform.

I need to be able to see the change in that query before I leave, The last field to enter is a number field - what event can I use to tell access that I'm finished with my entry, save and requery all the under lying tables and queries?


Referencing a form in a subform
I currently have a form (which I use to input data into my tables) Next to it, I have a subform, which uses a few simple dlookup functions to spit out some important end-result values as a FYI to the user. It is reporting the correct values for the first entry in the form, however I want it to update as I scroll through different entries. Does anyone have any ideas how to "refresh" the subform every time I go to a new entry? Is there a way to reference the "currently being viewed" entry on the form


Getting a Subform to only show related information
I am trying to make a form using the following tables:

I can create a form from the "Website" table and my "history" table will show up as a sub-form. This is what I want, because the history table is meant for storing notes

However, a 3rd table, not pictured, is used to make a query with the website table. No subform is created by default (bad) When I try to add a history table subform, the history data is not filtered against the currently displayed entry.

I know what the problem is: the subform is not filtering the data it displays based on the entry data. My question is, how can I get the sub-form data to link with the displayed entry


stop the "data entry" field from changing when a form opens
me,
I have a form with a combo box and two subforms, the combo box has a list of names, when one of these is selected the first subform is populated with a list of clothing types that is related to the name selected from the form combo box, when one of the clothing types of the first subform is selected it allows you to enter the second subform so you can enter new data about the clothing that was selected from the first subform.
In the properties of the second subform I have the "allow additions" and the "data entry" fields set to "Yes".
My question is, when I run the form and select the name from the form combo box the "allow additions" in the second subform stays "yes" but the "data entry" field changes to "no", when I open the subform in design view these fields are still set to "yes" is there a way of stopping the "data entry" field from changing to "no'' when the form/subform opens


subform controls
I havea form. it has a main form and 2 sub forms. on data entry I need to be able to enter data on main form then it on enter it goes to first field of first subform which is great. then on last field of first subform it will not go to first field of next subform. it keeps going to back to first fireld of same form not to next sub form. how can I get it to go after tab or entry to first field of next subform


MS Access - Subform
I want to consult with users in this forum the following:

my database contains a form which includes a subform.
What command through VBA or macro I can set the action of opening the form:
1) mode of data - the addition (to form & to subform that is displayed as a data sheet)
2) mode of data - modifications (in the form of records and also a datasheet subform, which belongs to the entry of the main form).

Basically, this is the mode setting data for each subform when the main form is opened.


MS Access - Subform
I want to consult with users in this forum the following:

my database contains a form which includes a subform.
What command through VBA or macro I can set the action of opening the form:

1) mode of data - the addition (to form & to subform that is displayed as a data sheet)
2) mode of data - modifications (in the form of records and also a datasheet subform, which belongs to the entry of the main form).

Basically, this is the mode setting data for each subform when the main form is opened.


stop the "data entry" field from changing when a form opens
I have a form with a combo box and two subforms, the combo box has a list of names, when one of these is selected the first subform is populated with a list of clothing types that is related to the name selected from the form combo box, when one of the clothing types of the first subform is selected it allows you to enter the second subform so you can enter new dataabout the clothing that was selected from the first subform.

In the properties of the second subform I have the "allow additions" and the "data entry" fields set to "Yes".
when I run the form and select the name from the form combo box the "allow additions" in the second subform stays "yes" but the "data entry" field changes to "no", when iopen the subform in design view these fields are still set to "yes" is there a way of stopping the "data entry" field from changing to "no'' when the form/subform opens.


Subform data entry is set to YES but it displays all records on refresh
On a default startup form (switchboard) I have a combobox in which one selects the username (bound to StaffNum) and clicks OK to open up the mainform.

On the mainform I have a data entry form that has its DATA ENTRY option set to YES.
for StaffNum field, I set the Default Value as

1) =[Forms]![Switchboard]![cboStaffNum]
initially the form opens up as data entry, but after inserting new records, and hitting the refresh button, all records are displayed in this subform.

Refresh Button Code:


Search Function so that data will populate the form
I have built a database where other users will be entering the data. The data entry form has a subform with data from another table. The main form is a constant (customer information) but the subform is for each transaction being recorded.

I want to be able to create a record search and edit function from the switchbox that filters by the customer id number then populates the data in both forms using a the design of the data entry form.

I want to make this user friendly. I don't want to use a combo box because the database is going to be too big.


Keeping Currency Field Null in New Record in Subform
I have a form linked to a regular table and a subform linked to a junction table.
The subform has four fields, 3 combo boxes, and the currency field for manual data entry.

The subform is set a Continuous Form.

When I use the subform to create a new record, the currency field gets automatically populated with $0.00 as soon as I make a selection using the combo box in the subform. I can manually delete it, but I don't want it to appear automatically.

How do I prevent the $0.00 from being added? I need the field to remain blank until I make an entry


Keeping Currency Field Null in New Record in Subform
I have a form linked to a regular table and a subform linked to a junction table. The subform has four fields, 3 combo boxes, and the currency field for manual data entry.

The subform is set a Continuous Form.

When I use the subform to create a new record, the currency field gets automatically populated with $0.00 as soon as I make a selection using the combo box in the subform. I can manually delete it, but I don't want it to appear automatically.

How do I prevent the $0.00 from being added? I need the field to remain blank until I make an entry.


Keeping Currency Field Null in New Record in Subform
I have a form linked to a regular table and a subform linked to a junction table.The subform has four fields, 3 combo boxes, and the currency field for manual data entry.

The subform is set a Continuous Form.

When I use the subform to create a new record, the currency field gets automatically populated with $0.00 as soon as I make a selection using the combo box in the subform. I can manually delete it, but I don't want it to appear automatically.

How do I prevent the $0.00 from being added? I need the field to remain blank until I make an entry.


Form/Sub Form Woes
I have a form that allows entry of customer details.
Beneath that is a subform that allows custoemrs vehicles to be input.

The Key field on the main form is Called ID (AutoNumber)
The CustomerID field on the subform is a Long Integar.
This is how they are linked together.

The subform is set to allow Data Entry.

However, when I fill in the customer details and click or tab intot he vehicle subform, the details from the customer are saved and the form goes blank to input a new record.

How can I get the subform to remain open to input vehicles.


Entry into subform
I have a form with a subform were you enter the data into directly, does anybody know how to change the view so that first row is left blank ready for new data, instead of the last