Populate Form

Jun 8, 2006

I have a simple question I am sure for others.

I have two forms.

Entry form--it is used to load data as well as I want it to be populated and show data when called upon.

Pending form--it shows all pending groups.

The pending form is a continuous form and it has a button with a double click event.

When that button is doubled click, I want the 'Entry Form' load and to be populated with the data that is in the Pending form.
The pending form only shows the EntryId(PK), Group name, and date. The 'Entry form' shows everything.

Since the entry form is used to add/update records in my tables, I wanted to use it to allow the user double click the record in the pending form and bring up that entry form for updating.

MAkeing a long story short, how do I populate the entry form with the records based on the entryID in the pending form.

I've attached a copy of the db incase I don't make sense.

View Replies

Forms :: Continuous Form - Click On ID To Populate Single Form

Oct 4, 2013

I have a continuous form that displays all my customers .I want to be able to dble click a customers ID and go to there customer details form.

View 14 Replies View Related

Forms :: Populate Field In One Form From Text Box In Another Form

Jan 18, 2014

There are two forms invoolved in thi

pfrm_AddClientPrimary
pfrm_AddClientDuplicateCheck

On a command button in pfrm_AddClientDuplicateCheck I have the following code.

Code:
Private Sub cmdAddNewClient_Click()
DoCmd.OpenForm "pfrm_AddClientPrimary"
DoCmd.Close acForm, "pfrm_AddClientDuplicateCheck"
End Sub

This works great

On the onOpen event of the pfrm_AddClientPrimary form I have this code

Code:

Private Sub Form_Open(Cancel As Integer)
Me.FirstName = Forms!pfrm_AddClientDuplicateCheck!txtFirstName
Me.LastName = Forms!pfrm_AddClientDuplicateCheck!txtLastName
Me.SocialInsureanceNumber = Forms!pfrm_AddClientDuplicateCheck!txtSOcialInsureanceNumber
Me.FirstName.SetFocus
End Sub

This fails on the first line with this error
Run-time error 2147352567 (80020009)
You can't assign a value to this object

I am aware of the incorrect spelling of Me.SocialInsureanceNumber this is the way it is in the db.

View 4 Replies View Related

Forms :: Pre-populate Popup Form After Update To Another Form

Aug 27, 2013

I have two tables - Interviews & Placements.these tables have multiple foreign keys which pull information from other tables (CandidateID,ClientID etc). I have designed queries and forms (datasheet view) which display all the values that I need, For example:

The interview form shows the following fields:
CandidateName;Company;consultant;1stInterviewDate; 2ndInterviewDate;Offer;Accepted

the placements form shows the following fields:
PlacedCandidate;Company;Consultant;PlacementDate;F ee;

This query "qry_Interviews" populates these forms using the foreign keys:

CandidateID from candidates table
CompanyID from companies table
consultant from consultants table

Ideally what I'd like to happen, is when the "accepted" field is updated on the interviews form, the placements form opens as a pop up and is auto populated with the values (CandidateName;Company & consultant).So far I have tried setting the value directly, i.e on the "on Open" event of the Placements form I entered:

Me.Txtcontactname = Forms!ISISnavigationMain!navigationSubform.Form!DS .Name

This does not work. Should I be populating the placements form with the actual Foreign key values rather than the resolved names? Ideally I'd want the pop up placements form to display the actual names rather than just ID numbers.

View 4 Replies View Related

Use SQL In VBA To Populate A Text Box On A Form

Nov 21, 2006

I know how to do this with a combo box. After defining the SQLtext and WClause something like:

with me.cbocombobox
____.rowsource = SQLtext & Wclause
____.requery
end with

How do I (can I?) use the SQL in VBA to populate a text box in a similar manner? I have tried various versions of me.textbox = sqltext & Wclause etc, but to no avail.

Cheers.

View 2 Replies View Related

Populate Form From Other Tables

Feb 27, 2005

I have 5 tables (Client, Driver, Appointment, LessonType & Booking). The Booking table is empty as it is made up from the other 4 tables. I want to have a form (Booking) which collects data from the 4 tables to create a record.

I want this to be automated as much as possible rather than typing the data into a textbox, because this would be difficult for the user and there would be conflict.

The Booking form will be split into 4 sections relevant to the above tables. For example, select ClientID from a combo and the other fields populate, such as forename, surname, address1, address2. And then select DriverID and this populates the relevant fields and so on, until a booking is created.

Ive tried After_update and couldnt get that to work. Any suggestions or help will be much appreciated as this has been a headache for a few weeks now. Thanks

View 9 Replies View Related

Auto Populate Next Form

Nov 11, 2005

Hey all,

Maybe im just having a brain fart, but I cant get this method to work.

There are two forms, the first records Two Names, The Bride and The groom along with their wedding date and where they registered. After all the data is entered on the first form, the first form is closed, and the second one is open.

What I would like to do is pass the info from the first form on to the second one. The second one uses the bride's info and the wedding date.

I tried using the query to fill it in but I havent had any luck. Been a long day.. maybe just not thinking clearly.

Any help would be appreicated, and thank you in advance to any replies!

Thanks!
Mateo

View 1 Replies View Related

How To Populate A Field In A New Form

Jan 13, 2006

I have attached a sample of my DB so you can see for yourself what i am trying to do. I want to capture the SSN on the search page so when I go to P1 or P2 that persons info is all ready populated on the right side of the page, but still allows for a search after I have updated the record.

Any help is greatly appreciated.

View 10 Replies View Related

One Form - Want To Populate Two Tables At Once

Jun 9, 2006

Hi

I have a form created from Table1

I have another Table2 - which is identical to Table2

I want Table2 to automatically update with the information put on the form (which currently only populates Table1) without asking the user whether they want to do this. And when I say update, if a user adds a new record to the form, I want that new record to be put on Table1 and Table 2.

I am using Access 97....

Help :)))

Thanks

Maria

View 3 Replies View Related

How To Populate A Form From A Combo Box

Oct 5, 2006

I'm creating a form that will have a combo box and several other fields on it. From the combo box, I want to be able to select a line from the combo box, click on the line and then have the form's other fields get populated.

I know I have to have the combo box and fields tied to either a table or to an underlying query, but what might be my best way to get the form populated?

Should I, in code tied to the form, run some coded SQL based on what I select and use the SQL results, or should I use something like recordsetclone, of which I have no experince?

Thanks inadvance to thoe who respond!! I reallyappreciate your help!!

View 13 Replies View Related

Populate Three Tables From One Form

Aug 27, 2004

I am having the hardest time with this.

Tables: Employee Record
HR Record
Orientation Record
Certification Record
Optional Certifications

All are related.

I have a form where I do data entry, with all of the fields from these tables on the form.
I want to type in the name only once, at the top of the form, and then have it populate the
Name field in EACH of the above tables. Can anyone help me with this? I've been working on
it for two weeks now. I'm sure it's an easy fix that I haven't thought of.

I've already tried using subforms, but unless I type in the name in each of the subforms for
the above tables, I end up with blank name fields in all the tables, except for the one I pointed
the data to go to.

I'd be SO grateful if someone could help me figure this out. Thanks!

Kelly

View 5 Replies View Related

Populate Form From Other Tables

Feb 27, 2005

View 12 Replies View Related

Using A Query To Populate Fields In A Form??

Feb 7, 2006

I have very minimal knowledge of MS Access and I have to create a database to input, update and display project information. How do I write a query to populate fields on a form, from either a single table or multiple tables?

View 3 Replies View Related

Auto Populate A Text Box On Form

Mar 16, 2005

I have a form with a text box named HRName.

When I populate a combo box named BusOrgCode, I want to auto-populate the HRName box with the name that corresponds with the Bus Org Code. I get a run time error "2001." Help!

Here's my code:
+++
Private Sub BusOrgCode_AfterUpdate()

Dim strFilter As String

' Evaluate filter before it's passed to DLookup function.
strFilter = "BusOrgCode = " & Me!BusOrgCode

' Look up HR Partner Name and assign it to HRName control.
Me!HRName = DLookup("HRName", "HR by Bus Org Code", strFilter)

Exit_BusOrgCode_AfterUpdate:
Exit Sub

End Sub
+++

View 2 Replies View Related

Auto Populate A Form Field

Sep 22, 2005

I have a form with fields "Assigned To" and "Assigned Date". When "Assigned To" receives a value, i.e. Not=Null, I want to auto-populate the "Assigned Date" field with the current date and time. How can I do this? Any help is appreciated.

View 4 Replies View Related

Populate Form By Entering Data

Jan 23, 2006

I have a form with two fields, EMPLNO and SURNAME.

By entering the employee number in EMPLNO or by entering the name in SURNAME I wish to get the correct record onto the form.

This is probably covered in the archive, but I'm not sure what to look for.

Any suggestions.

View 1 Replies View Related

Using A Table To Populate 3 Form Fields

Mar 17, 2006

Hi

I have a form with 3 combo boxes part No, Description, Cost. I have created a table with this information in I want to be able to select the information from either one of the three drop down boxes and the other two to automatically collect the information from the other colums of the table. Can anyone help please?

View 2 Replies View Related

Populate Form Fields On Open

Aug 7, 2006

Hi all,

I'm sure this must be a well used function by many access users but I can't find anything about it online at all - please help!

I want to open a subform "AddReservation" and populate three fields with data taken from the relevant record in the main form. So in the btnOpenAddReservation_Click event to open the subform I set global variables, then in the form_open event I have this:

Private Sub Form_Open(Cancel As Integer)

Me.CatID = stLinkCatID
Me.CatName = stLinkCatName
Me.OwnerID = stLinkOwnerID

End Sub

But I get the error 2448 'Can't assign a value to this object'.

However if I put the same three lines into the start of the subform's btnARSave_Click event it works fine:

Private Sub btnARSave_Click()
On Error GoTo Err_btnARSave_Click

Dim stDocName As String
Dim stDocName2 As String
stDocName = "OwnersAndCats"
stDocName2 = "AddReservation"

Me.CatID = stLinkCatID
Me.CatName = stLinkCatName
Me.OwnerID = stLinkOwnerID

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

YesNo = MsgBox("This reservation has been added successfully, do you want to add another?", vbYesNo + vbQuestion, "Add More Reservations?")
Select Case YesNo
Case vbYes
DoCmd.GoToRecord , , acNext
Case vbNo
DoCmd.Close acForm, stDocName2
DoCmd.Close acForm, stDocName
DoCmd.OpenForm stDocName
DoCmd.GoToRecord , , acGoTo, stRecordNo
End Select

Exit_btnARSave_Click:
Exit Sub

Err_btnARSave_Click:
MsgBox Err.Description
Resume Exit_btnARSave_Click

End Sub

What am I doing wrong? Why can't I populate the fields on open?

Many thanks
PT

View 1 Replies View Related

Populate A Form From Existing Data

Sep 13, 2006

Hi
I cant get my head around this one,

I have a Form that enters all details for an Order.

On that form is a Tick Box that says Repeatable.

If that box is ticked in the future I am able to repeat on that stock item.

I have created a form with a List boxea that Lists all Suppliers Stock that is Repeatable

I want to be able to double click a Stock Item from that list, then let it populate another Order ( Unique Key ), fill in all the field from the previous order, so all I have to do is enter the Quantity I want to re-order.

How do I do this?

please help

Hightower

View 4 Replies View Related

Auto Populate User Name In Form

Aug 3, 2004

I am need of something that will help me auto populate the user name on a form. What I am thinking of is setting something that is diplayed when the form is open, asking users to enter their name. I then want this name to be populated in the user name of each record they update.

Can anyone help me? This sounds like a pretty easy thing to do , but sometimes what I think should be easy turns out to not do-able!

View 14 Replies View Related

Can You Populate A Unbound Continious Form

Feb 18, 2005

Can you populate a unbound continuous form. If yes how do I do it

Phil.t

View 8 Replies View Related

Auto-populate Form Field!

May 2, 2005

Hi, just a quick question that i hopes not too hard.

Basically i want one of the fields on my form to get automiatically filled in. I'd like it to take the first letter from one field and the first letter from another field. What im trying to do is make a primary key field up from other fields they have entered.

So for adding new customer i want it to take the firstletter of the firstname and first let of the surname.

SO for myself Luke Tarrant it would be LT. Then i suppose i'll need to add some unique so there no duplicates as it a primary key field im trying to populate.

So for instance Luke Tarrant would = L + T +001

Then Lucy Tarrant would = L + T + 002

Any help wouild be brill!

View 6 Replies View Related

Populate Form Fields From A Combo

Jul 30, 2005

Trying to update fields (bound) on a form (built using the wizard) from value selected in a combo box. I can get this to work with unbound text boxes using an After Update event handler and a code query along the lines of:

Me!TxtJobCode1 = Me!CboJobDesc.Column(1)

But this doesn't work where the form field is bound to a table.

So qu is - how do I achieve the same result using table fields instead of text boxes?

I could use text boxes but not sure then how I can save that data as a record in the table if it is not bound to fields.

Any help appreciated

Andy

View 1 Replies View Related

Forms :: Using A Scanner To Populate A Form

Oct 22, 2013

I have a table which contains 2 fields. UserID and FullName..Each employee is assigned a barcode (UserID) and what I would like is when they scan their barcode into the form their name comes up. There is a second table containing records of documents and I am hoping that this form will allow an employee to scan their ID, their name comes up, scan a document and the title of the document comes up, there would be a current date box and then that whole transaction is saved as a record in another table. Long story short I want to know who is accessing what records and to have it logged.

View 5 Replies View Related

Forms :: Open And Populate A Form

Jun 12, 2014

I am trying to open a form from my main form and populate fields from one to the other (then press a button).if the form is opened in dialog mode then the code won't run to populate the form (until it is closed or not visible).

The main form is showing an address, but the user can click a button to amend this. Once clicked, the Property Form is opened - I don't want the user to need to fill in all the address details again. I want this pulled through from the main form so the user can make an amendment, then save the new address.

Code:
DoCmd.OpenForm "frmPropertySearch", , , , , acDialog
With Forms!frmPropertySearch
.Form.Visible = False
If Not IsNull(Me.Building_Name) Then
strBuildingName = Me.Building_Name
.txtBuilding_Name = strBuildingName
End If
End With

View 3 Replies View Related

Unbound - Populate Textbox In Form

Nov 13, 2012

I'm trying to populate a form textbox which is unbound.

I have table with a list of peoples login names and a query filtering these names once a user logs in. If the GetUserName() matches one of the names in the table then user is authorised. this part seems to be working fine. User not on the GetUserName() list the filter says blank ie Not Authorized.

How to take this confirmed user name and place it into a textbox on a form?

Table name: [tblUserNames] with [IngEmpID] & [UserName]

Query Name: [qryUserNames] with a Criteria GetUserName()

View 7 Replies View Related