Field To Autofill Based On Value In Another Form

Sep 13, 2012

I have a review pop up form (frmReview) where a user selects their Name (StaffID), the type of check they are doing (QuailtyType), and the client they want to do it on (clientID). When they press on the 'do review' command button from this form another form opens (frmReviewDetails) which shows the client they selected from the frmReview form as well as a its subform which shows all the sessions that have been entered for this client along with some fields that have not been complted yet regarding review data. I am trying to have it so when they check the 'review check box' in this subform that today date auto populates in the Review date field (this is currently working). I also want it to auto enter the staffID that they selected on the the initial frmReview form.

This is my currunt code:

Private Sub Rev_AfterUpdate()
If Me.Rev = -1 Then
Me.[RevDate] = Now
Else: Me.RevDate = Null
End If
End Sub

I really don't want a staff to have to enter their name each and every time they check the review box. Not all box's are going to be checked, so it needs to be on a record to record basis.

View Replies


ADVERTISEMENT

Forms :: Autofill Field Based On Related Field In Previous Form

Jun 30, 2015

I have my Assets form and the primary key is the ChargerID, in this form I have an "Add New Job For This Asset" button, which opens up the Jobs form at a new record.

How do I make it so that the ChargerID field is automatically filled with whatever the previous record was instead of being blank.

For example if I have Charger12345 open in the Asset form, I'd like to click the Add New Job button and it automatically have Charger12345 in the ChargerID field of the Jobs form.

View 5 Replies View Related

Autofill Field Based On Previous Value

Dec 27, 2005

I am trying to autofill a field based on the value of a previous field on a filtered form. I think the fact the records are filtered is throwing me off. Any help for me?

View 9 Replies View Related

Autofill Fields Based On Results From Another Field In The Table?

Apr 18, 2007

I have an Access database with several tables and a multitude of subforms which are displayed on a single master form. The subforms are used to facilitate data entry. In several of the tables there are fields which are related and I would like to have some of these fields updated based on the results entered in the related field (i.e. the answer for one field depends on the other).
Field 1Field 2
[facing][DISC_CODE]
un3
up1
dn2

Field 1 is a simply a description of the basic dataset. This field is already set-up on form as a combo box that allows the user to choose one of three options. Field 2 is a code number used by another piece of software to identify a particular symbol. It is a new field being added to the database. There are 200 codes that identify a wide range of symbols for different types of data and I don’t want to have to look them up when I, or my assistants, are doing data entry.

My question is this; is there anyway to have the DISC_CODE value, Field 2, automatically entered in the table when the value for Field 1 is selected in the combo box on the form?

View 1 Replies View Related

Tables :: Autofill Future Date Based On Another Field

Dec 1, 2014

I am very new to access and I am trying to figure out how to build an expression for one of my fields. I have a field called Order Date, which holds the date of when an order is filled. I then have another field called Fill By Date. This new field I want to be 2 weeks after the Order Date. Is there a way to auto fill this information so that when I enter a date into the Order Date, it will enter the date that is 2 weeks after into the Fill by Date?

View 4 Replies View Related

Autofill Field Based On Value From Table Using DLookup Not Working

Jan 8, 2013

I am new to Access (using Access 2012) and All I am trying to achieve is to autofill the field [Frequency] from Table FullList based on the value of [Frequency] from Table Courses using a DLookup code used to update the FullList form. The code is not updating anything! It is frustrating! Frequency is a number (integer) and while Course is a text. The figures of my Access database are below.

View 2 Replies View Related

Tables :: Autofill Entry In Record Based On Form

Aug 15, 2015

I want to be able to pre-fill records with information based on a form every day for each client. This needs to display in a datasheet view showing all clients for each location.

Each day the subform needs to show the expected results of that day's activity with clients if all default conditions are met. (i.e. client receives a call that day based on expected conditions calculated in a form for that day).

View 3 Replies View Related

Access 2007 - Autofill A Form Field Depending Upon Value Of Another Field

Feb 20, 2012

I am new to Access 2007 and I am having trouble in creating a form. It is simply a data storage table which would be fed in by users. That it.

I need to create a user friendly form so that :

When the user selects : Career_Goal field as "None", the next field called: Years, should be automatically be populated as 0.

In any other case, they should be able to select the years from the dropdown list.

How do I create this if else conditions? Do I use expression builder, if yes then how?

View 1 Replies View Related

Forms :: Autofill One Of The Field In Form

Jan 14, 2014

I want to Autofill one of the field in my form, by checking specific conditions in my database. Example of which is as below:

1. Date of Maintenance :
2. Loom No. :
3. Component Replaced :
4. Component Type :
5. Latest date for same component replacement :

I want to autofill the Sr. No. 5 in the form itself by checking database, and if Sr. No.2=Sr No.3=Sr. 4, then latest date should be autofill in Sr. No. 5

Say, A component was replaced in a Loom on 01/01/2013 & again after six month same component is replaced on 01/06/2013 so while filling up the form, In sr. no. 5 latest date 01/01/2013 of replacement of same component in same loom should be pulled from data base.

View 1 Replies View Related

Autofill Based On Selection - Please Help

Sep 28, 2004

I am learning Access fairly quick, but still a newbie and stuck on an autofill problem. I have read everything I could find and it seems there may be code involved, which I'm not sure about.

The problem seems simple enough: I want to populate field "Rate" in the table "Services" based on the selection from a dropdown menu referencing ClientID in the Clients table. Specifically, my form uses a drop down menu to select ClientID for the Client table to associate with fields in the Project table and I have imbedded another form at the bottom which contains fields from the Services table including the Rate field I want autofilled based on the ClientID selection. Here are the tables and fields I'm working with...

...table...
Client
...fields...
ClientID (PK)
Rate
<and more>

...table...
Project
...fields...
ProjectID (PK)
ClientID
<and more>

...table...
Services
...fields...
ServicesID (PK)
ProjectID
Rate
<and more>

Please be easy on me if this is a simple problem. Thanks!!!

View 7 Replies View Related

Link And Autofill A Name Based On NumberID

Apr 29, 2006

I have a main form for a tblCommittee and a subForm 'sfCommitteeOfficer' that will eventually take an entry or show -if its existing, a list of Committee officials. The officials come from a 'tblMembers'. There are too many members to use a drop down list box to select the MembNumber. What I wanted to do was be able to enter the MemberNumber in a txtBox 'MembID' on the form in the row containing Memb#, MembName, Position i.e chairman, Date elected Date retired, and have the members name automaticlly entered into the field MembName of the subform to limit the amount of entering the user has to do!
Is this possible? I have a tblCommiteeType with key field CommitteeID, and foreign Key MembId, so I dont think I need a tblCommitteeMember because names are already stored in tblMembers.

View 3 Replies View Related

Autofill Text Boxes Based On Combo Box

Sep 13, 2006

:confused: I have a combo box on a form that is used for data entry that allows the user to pick the date. This is based on a table that includes date, week ending date and month, all very specific for our business. I used a function that says Me.txtBox=ComboBox.Column1 for example. So my combo box would include all the information, and all but the actual date is not visible. I want this to feed into another table that will be used for reporting, and that table has the same fields of date, week ending date and month. I keep getting an error saying that the value selected from the combo box doesn't fit the criteria, and I believe what is going on is that it is taking all the fields instead of just the date. Any suggestions how I can still have the text boxes update if I only have the date in the combo box?:confused:

View 1 Replies View Related

Modules & VBA :: Autofill Cell Based On Previous Record Value

Aug 26, 2014

I am trying to write some vba code to auto fill a cell's value based on the value of the cell in the previous record (In a datasheet form) i.e. if the value in record one was '1' and the down-arrow key was pressed then the value '2' should be entered into the new ext record

I have written some pseudo-code to show what I am trying to accomplish:

if keydown = down-arrow and current cell contents isnumeric then
Cval = current cell contents
if current record = last record then
create new record
move down 1 record
set cell value of new record to cval+1
else
move down 1 record
if cell value = null then set cell value of record to cval+1
end if
end if

View 14 Replies View Related

Reports :: DLookup Criteria - Autofill Product Name Based On ID

Apr 2, 2013

Im trying to make an invoice,

Im trying to autofill the products name using a dlookup

The ProductID1(2,3,4 OR 5) is selected from a list in a form and is sourced from "Products!ProductID"

=DLookUp ("Products!PName","Products", where "ProductID1" = "Products!ProductID")

How do i make this work,

Without the "critera" the lookup returns only the 1st record of "Products!PName" for every transaction even though the ProductID1 differs

How to i get it to show the correct corresponding name to ProductID1??

Ive attached a screenshot....

View 3 Replies View Related

Tables :: Column To Autofill Based On First Digit Of The File Number

Dec 26, 2012

I have a datasheet with 7 columns. Two of the columns I'm working with are listed below.

File # Region #
2DE2-12345 2
3DE2-@@@ 3

In data sheet view I would like the Region # column to autofill based on the first digit of the file #. So, if file # entered = 3DE3-@@@@ then 3 would auto fill in Region Column. (data is entered in data sheet view)

I have used Left ([File #],1) to get value but cant make it auto populate the Region # column......

View 6 Replies View Related

Autofill Of 1 Field

Apr 27, 2006

I have 2 forms (school and venue)

I have a button on the school form that opens the venue form. I want the school field that is on the venue form to auto fill with the same information that is in the school field on the school form. Any help would be awesome.


Martha

View 2 Replies View Related

Copy Autofill Primary Key Field To Another Field

Jun 17, 2012

My table called Table1 has a primary key field (called RefID) with AutoNumber format. My problem is I want duplicate value of RefID field to another field called DupID. I want DupID to be changed, but I don't want any change on RefID field whenever I make changes.

View 5 Replies View Related

Autofill Field With Employee

Dec 23, 2005

Hello all!

Ok, lets get down straight to the point.

What i want to achieve is that when i login that automaticly the name has been filled in on every form.

I have a login form. I put my name in there like "Michiel" and ofcourse the password. After that its going automaticly to the mainpage. In that mainpage i want to create a field that automaticly filles in my name (so if somebody else log in that their name will be filled in). After that i want when i go the incident form that automaticly the employee form has been filled in. (The person that at the moment is logged in that his name automaticly been filled in) Ive tried various ways to achieve this goal but nothing worked.

Im not that very expert in Access but im trying to understand and learning pieces by pieces the Access world. So if somebody could help me because im getting desperate! Thanks in advance all! :D

Greetz.

Creegfire

View 4 Replies View Related

Have Data In 1 Field Autofill Another, Easy?

Mar 28, 2005

Here is what I want to do. I have a table called "TblRates" and in the table are two fields called "Description" and "Rate" the description field has data in it like "PC Repair", "Onsite Repair" and the "Rate" field has currency data "$50.00" and "75.00". I have a for called "FrmRates" and I want to be able to select "PC Repair" from the "description" field and have it auto fill "$50.00" into the "Rate" field and the same for "Onsite Repair" and have it bring up"$75.00". That is the best way I can describ it. I would like to either know a macro or somthing easy I can type in VB code which I know nothing about. Please Help

View 2 Replies View Related

Autofill Field From Selection In Combo Box

Jul 27, 2005

Hi all,

I am fairly experienced with Access but am stumped. I have a table with a primary key ID field, product name, and product price. On an order form, I want to select the product from a combo box and have that product's price automatically populate a text box beside it for further calculations. Any help would be much appreciated, thank you!

View 14 Replies View Related

General :: Autofill Field In Table

Mar 17, 2014

I have 2 tables: A and B with field names:
ID, Title, Link

and one table C with:
ID, Title

The Link in each table "points" on another table.A points on B that points on C.(When you fill in column Link in table A or B, a Lookup table is used so that I can select one of the titles in the linked table).I want to add a new field name called Position in table A and B. The Position is supposed to describe the cells place in the tree.

Example: if A with ID 1 points on B with ID 2, and B with ID 2 points on C with ID 3 then in A Position data field it would say: "3.2.1".I would like it to autofill Position when I add a new title.

View 1 Replies View Related

Forms :: Button To Autofill A Field In All Records

Oct 21, 2014

I know all of the main features and can even do a bit with macros and VBA. I need creating a button to auto-fill a field in all the records in a table.

I have a database centered around a table called tblCand; each record contains a date field called intDate. On the main form, initDash, when the user hits a certain button, a window pops up (either a message box or perhaps a separate form) that asks the user to type in a date, which would be stored as intDateDB. When the user hits OK, I want the value of intDateDB to replace the value of intDate in all the records in tblCand.

I'm not sure whether this is called auto-filling or auto-populating...

View 11 Replies View Related

Modules & VBA :: Updating A Field In A Form Based On Another Table Field

Sep 13, 2013

Using Access 2010. Fairly new to automation and macros.I have two tables (tblProductReceived and tblBins) and a form (frmProductReceived).A field in tblBins corresponds to a location the bin is at (named BinLocationID) and the tblProductReceived table tracks product that a specific bin has received.

What I need is for the tblProductReceived field PRLocationID ([tblProductReceived].[PRLocationID]) to be automatically populated with where the bin is at ([tblBins].[BinLocationID]) when selecting a specific bin in the form (frmProductReceived).

View 1 Replies View Related

Forms :: Coloring Form Field Based On Another Field Content

Jun 4, 2013

I am making a very simple 'registration' database for a children's event in a couple of weeks.I the table/form there is a checkbox field called 'consent' which, if checked, indicates that a child can leave the event without parental consent.

There is a report printed on each child (a registration page which the leaders get a copy of). I would like on this report a 'red box' to appear if the child cannot leave without permission (i.e. the consent box is not checked). I would also like this 'red box' to appear on the form. I had thought of doing it this way - but I'm not sure if it's the best, or if it's possible:

Have a field in my table called 'consentindicator'. When the 'consent' box is checked, there is a period ('.') placed into the 'consentindicator' field. It is set to turn red when a period is present. That way, when the consent box is checked, a get a red 'box'.

View 12 Replies View Related

Autofill Text Field Using Combo Box Selection To Generate Autonumber

Dec 10, 2013

Autofill text field using combo box selectionHello,

I'm trying to autofill a field on a form using MS-Access 2010 Web version sharepoint using macros without coding.

The form has an existing Combo Box field called Segment, using the row sources "REW", "WTT", "DBM".

A user begins filling out the form and eventually selects the Combo Box for Segment and selects any one of the segment no Multiple selection

There is another text field, which is actually alpha-numeric, called Job_No. I want this to autofill based on their Segment selection, using this format:

REW-YYMMDD-TTTT, or REW-131210-20001 for example, for today with the time displayed as military time and last Job No.(20001) for REW and Also for WTT (30001) as starting number.

View 1 Replies View Related

Autofill Form

May 24, 2006

Hello

I'm new to Access Programming and the whole Visual Basic bit and I have a project I need to finish.

Well I created a Form and what I want to do is this:

If I enter an ID number, I want the Form to populate the rest of the fields automatically (eg. phone number, address etc.).

Can you please give me ideas on how to do this? Thanks a lot. :)

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved