Forms :: How To Link Combo Box To Tab Controls

Jul 9, 2014

On my data entry Form, I have a Combo Box [Condition] and five tab controls. Each tab has as many as 10 controls on it. The purpose of the Form is to populate a table. My questions are:

1) Do I still need to use a subform on each Tab or leave them as-is? i.e. the 10 controls are on each tab

2) How do I make the value of [Condition] transfer focus to the appropriate tab??

View Replies


ADVERTISEMENT

Forms :: Hiding / Unhiding Tab Controls Based On Combo Box Selection

Oct 16, 2013

I have frmIncident that has a 2-column combo box (cmbIncidentType). Column (0) is IncidentType, Column (1) is YES/NO. This combo box feeds from a Query and currently has about 15 "types" of which 4 have a "Yes" tied to them, then rest "No".There are situated on a TabControl (tabIncident) with 5 sheet tabs. If the Incident Type selected in the Combo Box has a corresponding "Yes" in Column (1) then all 5 sheet tabs need to be visible. If it is "No", then only three of the five are visible. Here it he current code I am using for the AfterUpdate event on the combo box:

Private Sub cmbIncidentType1_AfterUpdate()
If Me.cmbIncidentType1.Column(1) = "Yes" Then
pgEmerIncidentRpt.visible = True
pgNarrClose.visible = True
Else

[code]...

When I open the form is will set the proper sheet tabs that need to be visible, however once I cycle to the next record, or select a different Incident Type, even one with a "YES' in column (1), it will only show the (3) sheet tabs. I can never get it to show all 5.

In the code, the only (2) sheet tabs that need to visible = true or visible = false are shown, starting with "pg".

View 3 Replies View Related

Subform In A Form Doesn Show Controls When Link Child And Master Fields Derfined

Jun 13, 2005

Hello,

I have a form and a subform in MS Access 2003. I have made some changes to database structure, so I decided to change the subform also. When I changed the Link child and link master fields, the controls of the subdatasheet dissapear- they show only in design view. If I clear the contents of Link child and link master fields they appear again, but the records are not binded.
Is there a setting on the parent form that also has to be changed, to make the new binding?

Thanks,
Aleksander

View 1 Replies View Related

Disabling ALL Controls On A Form Via A Combo Box

Aug 10, 2005

My database has a form with a combo box where the user can select whether the record displayed is "Current", "Sold", or "Withdrawn". I would like to set up the form so that when the user selects "Sold" or "Withdrawn" from the combo box, all other controls on the form are locked and disabled (ie. can't be changed).

What's the best way to do this?

View 4 Replies View Related

Refresh Controls Populated From Combo Box

Jun 29, 2006

I have a form where the user selects a client from a combo box.

Doing so populates 4 controls with info about the client, using the Exit function of the cbo box. The Record Source of the form in question does not store this info; it comes from a different table.

This works fine.

When the record has been saved and I come back to it, however, those four controls do not display the client's information, since the combo box hasn't been exited.

What's the best way to get the form to repopulate those controls without having to reselect the combo entry?

Thanks a lot for the help!

View 14 Replies View Related

General :: QBF With 2 Combo Boxes As Controls

Aug 12, 2013

What I am trying to do is, for example, I have 2 combo boxes, you can select a value in the first one and search and your results match the criteria, or you can select a value in the first AND second one and the records dispalyed will match the first AND second combo box criteria.

View 2 Replies View Related

Link Combo Box

May 12, 2006

Hi there, I am new to access and this question be a no brainer for you access gurus. What I currently have is a form with one combo box and two radio buttons.

Staff and Status

The staff combo box is a drop down menu of all staff members and is derived from a table called Employees. The two radio buttons represent "Active" and "Inactive".

So if John Smith is selected their current status will be shown on the radio button and the user can change it if they want to.

The problem I am having is linking the radio button to a name in the combo box. Any assistance would be appreciated.

Thanks

View 6 Replies View Related

Combo To Link Table

Jun 28, 2006

Hi.. i have a combo1(InvoiceNo) that look up the values in a table, (there are invoices numbers on it) In the Invoices table i have InvoiceNo (that is the key) and other fields like InvoiceCity, SaleDate, etc

I need to store the current date in Invoices.SaleDate = now() in Invoices table that matches with the combo1.

The Form has as RecordSource, Customers Table

Any tip or hint???

View 1 Replies View Related

Link 2 Combo Boxes

Oct 11, 2005

Hi,

I'm trying to link 2 combo boxes, so that the values displayed in the second combo are dependant on what is selected in the first combo.

I've referred to previous posts, in particular http://forums.aspfree.com/t32756/s.html&highlight=linking+combo, but I'm having the same problem...

The Row Source for my first combo reads as:
SELECT tblGroup.Group FROM tblGroup;

The Row Source for my second combo reads as:
SELECT [tblPart].[Group], [tblPart].[PartNo] FROM [tblPart] WHERE ((([tblPart].[Group])=[Forms]![frmQuotations]![qryEquipment subform].Form![cboGroup]));

I also have this code under the first combo's after_update event:
Private Sub cboGroup_AfterUpdate()

cboPartID.Requery
Me.cboPartID.SetFocus

End Sub

However, this brings up the 'Enter Parameter Value' msgbox asking for the cboGroup value.

Can anyone suggest anything I could be doing wrong?

Also, can someone confirm where I would find the subform's name...? Strange question I know, but I did not create this database, and under the subforms properties there isn't a field that specifically says 'Name'. Record source is 'qryEquipment', and caption is 'qryEquipment subform'. The form is also called 'qryEquipment subform' under the Forms tab.

Thanks in advance!

View 1 Replies View Related

Link Option Group To Combo Box HELP!!!

May 15, 2006

Hey all,

I am trying to link a option group to a combo box. The combo box has a list of employee names. The option group has two options Active and Inactive. All I want the user to be able to do is check the current status of an employee (as active or inactive) and to be able to change their status. I am having some troubles linking the two together.

Thanks

View 4 Replies View Related

Link Cascading Combo Fields To Table

Mar 1, 2005

This is my first attempt with cascading combo boxes (2) and with the help of the forum I've made it work BUT, I feel like an idiot because I'm drawing a complete blank on how to link them back to a "main" data table.

The example I used as a reference was to create them as unbound boxes while using queries to pull for each of the combo boxes. I have 4 tables. One will serve as the main table while 3 others are each feeding one of the combo boxes. I went back and set the main table as the record source and added some of the other fields but those unbound fields have me stumped.

If anyone recognizes an earlier post that clarifies this, please let me know. I've looked through numerous posts but haven't found one yet.

Just like everyone else, any help would be greatly appreciated.

mike

View 1 Replies View Related

General :: Combo / Text Box Link Causes Access To Crash

Oct 30, 2013

I've got a bit of a problem with linking a text box to a ComboBox. I have an employee name in a field [EmployeeName] that sits in the Header of a Form. (This is so I can show multiple records for that employee without having their name repeated at each one). I also have the name of contact [ContactName] that sits in the Detail area of the form.Both names come from their own tables that have all their contact numbers and e-mail addresses in columns I have linked the name to text boxes [ContactPhone] & [EmployeePhone] with their relevant phone numbers in within the Detail area of the form.

The ContactPhone that has the ContactName within the Details part of the form works well with no problems by putting =[ContactName].Column(1) in the Control Source

However when I put =[EmployeeName].Column(1) in the relevant Control Source (and / or EmployeeEMail in a second text box), once I have saved the form in Design view and returned to Form view, Access crashes and shuts down!If I remove the wording from the control source Access doesn't crash.

View 2 Replies View Related

Combo Link To Combo

Jan 22, 2005

:) Hi. Basically, I have a form with 3 combos - "from, to and type". What I'm trying to do is when a selection is made in "from", the "type" combo will select one of it's 3 options.

And i spose I'll be doing the same with other options.

View 2 Replies View Related

Tab Controls - Two Forms

Jun 2, 2005

Hello,

I want to use a tab form where the user can click add, search, and edit records all from 3 tabs. The problem is I only want to be able to add data on one form, edit data on another, and just read only on the search. This seems to cause a dilemma, how can I specifiy them to add, edit, and read only on one form using tabs?

Mateo

View 1 Replies View Related

Forms :: Dynamically Resizing Forms And Controls

Oct 31, 2013

I am making a database that will be used by multiple people on a network, and they have different resoloutions on their own computers. when the database is loaded on their respective computers, the form controls are all off.

On the computer i designed them on, the forms fit perfectly on screen, as do the controls, i would like to know if there is some vba code i could incorporate into the form open event, or module code that i can use in order to dynamically re-seize the forms and all of the controls to suit different resoloutions?

View 6 Replies View Related

Referencing Controls On Forms

Mar 30, 2012

I have a main form, 2 sub forms, and 2 text-boxes on the main form. I have a search box now for the first subform. Works perfectly. Once the users filtered based on name, I want them to be able to select that filtered record which would filter another subform.

Right? ok.

My first attempt was to assign the ID that was selected to a textbox on the main form, then automatically requery the second subform based on that value. I used this way on my search box. I'm sure there is a way to go directly from clicking the value to requerying the second subform, but i don't know it.

That being said even the indirect first attempt isn't working. It all has to do with the ".", "!", and ordering of this stuff. It has to do something with Parent child, but beyond that I'm at a loss.

Code:
Me.[Collateral] = Acct_Reference_id
Me.[Navigation]![textbox] = Acct_Reference_id
...
'Me!Subform1.Form!ControlName
'Me!Subform2.Form!ControlName
'Me.Parent!ControlName

I did find this very useful site [URL] ...... It shows what code you can use depending on where you are and what you're doing. Even with that as a resource, i'm still at a loss.

View 7 Replies View Related

Remove Controls On A Forms' Opening

Sep 29, 2006

Hi there,

I've been puzzling over this one for a few days. I've done a few searches on here to borrow some code - but the fact is I don't understand how to implement the suggestions. I'm hoping somone can help.

Basically, I have a form for editing the database, however, there are a number of reasons for opening this form - so at the moment I have several copies of the same form all with very minor changes. In order to streamline the way I've done this, I'd rather have controls always call up the same Form - but state in their code whether or not certain controls on the editing form are visible or not...

:mad: :eek: :mad: :eek: :confused:

It's all gone rather Pete Tong here. And I must admit I'm button bashing the code a bit now. Basically, when a button is pressed, I want it to load the form "frmEditJob". Depending on what I want visible, the Tags "N, M and V" will activate and deactivate certain controls on "frmEditJob".

With me? :confused:

Any help is appreciated!

Cheers.

Private Sub EditJob_Click()
On Error GoTo Err_EditJob_Click

Dim stDocName As String
Dim stLinkCriteria As String


If IsNull(Me![IDEntry]) Then
strMsg = "You need to enter a Valid ID number in the box provided."
strTitle = "ID Number Error"
intStyle = vbOKOnly
MsgBox strMsg, intStyle, strTitle
Exit Sub
End If

stDocName = "frmEditJob"
Dim ctl As Control

stLinkCriteria = "[WorkorderID]=" & Me![IDEntry]
DoCmd.Close
DoCmd.OpenForm stDocName, , , stLinkCriteria


If ctl.Properties("Tag") = "N" Then
ctl.Properties("Visible") = False
Else
ctl.Properties("Visible") = True
End If

Exit_EditJob_Click:
Exit Sub

Err_EditJob_Click:
MsgBox Err.Description
Resume Exit_EditJob_Click


End Sub

View 5 Replies View Related

Forms- Subtable Filtering Controls

Apr 28, 2008

Hi,

I'm new to Access and am having trouble designing a database that houses application details.

All applications have a list of unique wrap id's but have different tables housing different details for these wraps.

I have a main table which is for data entry and lets me input whether or not a piece of software is Vista compatible (yes/no) etc.

I also have a field in this table showing which analyst is responsible for researching compatiblity of an application.

I have another table with different regions i.e. london, manchester etc that has the region/city listed as the field heading and then contains a list of wraps used in that city under the relevant field.

My main entry form is linked to the main data entry table that holds specifics for an app, name, vista compatible etc. This form is used for data entry. I want to add a subform on this form which shows a list of all applications, in table format, but I want a drop down list so I can select an analyst name / region so that analysts can update details for a specific area assigned to them. In the table I want all of the records based on this criteria to be displayed.


I guess I need to make a filter button on my subform but do not know how to do this. I put in a button control for apply filter by form but then dont know what to do.

I'm new to access and don't know much VB - e.g. the only thing I can do in VB is a make a message box that says hello world on the screen.

Any help is sincerely appreciated. Apologies for the Essay.

Kind Regards
Bal

View 7 Replies View Related

Forms :: Controls Not Repainting After VBA Routine

Jul 23, 2014

Access 2007

I have a subroutine which cycles through all controls on a form, and for controls with applicable tags, either enables or disables the control.

The routine accepts a form as the parameter (frm), and is called from a button on the form itself.

Despite trying frm.repaint in the generic routine, and, me.repaint from the calling form, the controls do not seem to repaint until the mouse moves over them. A command button, for example, will be grey-ed out, despite being enabled, but will un-grey when the mouse goes over it.

View 8 Replies View Related

Forms :: Looping Through Subform Controls?

Aug 16, 2013

I have a main form, lets call it FrmMain. In addition, I have a subform on FrmMain that has a tab control on it (frmSubform). What I would like to do is on form load, reference the tab control that is on the subform, loop through the controls/textboxes, lock them and change their backcolor. The code I am attempting is listed below, however, I am getting a "type mismatch error" highlighting this line:

PHP Code:

Set Frm = Forms!frmConsultingMain!FrmConsultingFeeData 

Below is my code:

PHP Code:

Dim ctl As ControlDim Frm As FormSet Frm = Forms!frmmain!FrmSubformFor Each ctl In Frm.Controls    
If (TypeName(ctl) = "Textbox" Or (TypeName(ctl) = "combobox") Or (TypeName(ctl) = "listbox")) Then        
ctl.Value = Null        ctl.BackColor = vbYellow        ctl.Locked = True    End IfNext ctl 

View 10 Replies View Related

Forms :: How To Ungroup Controls On Form

Apr 29, 2014

I had never seen this before as I have recently moved from 2003 to 2010. When I create a from using the wizard sometimes the controls are grouped (inside a dashed square) which does not allow me to modify its size and/or position independently.

How can I "ungroup" these control?

View 2 Replies View Related

Forms :: How To Hide All Form Controls At Once

Apr 21, 2013

how to hide all form controls at once like if i have many text box and labels how to make a loop to hide it all at once

View 1 Replies View Related

Forms :: 2 Lookup Controls On One Subform

Aug 13, 2013

I have a library database with a form called Author and a subform from a junction table. The junction table connects Title/Genre. It's many to many because I usually have a few genres for one book.

This is my problem. I want to add more information to the subtable that is in the junction table. For every record I would like to add also Book Group (I am a member of several groups and want to remember which one I read the book with) and Purchased From.

So I am assuming I have to have 2 lookup controls to be able to add Book Group and Purchased from since neither one is on the junction table (and they both come from tables). Or do I add them to the junction table?

View 3 Replies View Related

Forms :: Hiding And Moving Controls

Nov 6, 2013

I have created a form with some boxes on it which include in their body textboxes and labels and combos. I would like to know if it is possible (or if a control exist) to group this items which are inside the box and with a simple box.visible = false to make them all non visible without tagging them or adding code with their names statically to make them non visible. Any link that shows how to move controls in the form in runtime?

I would like to hide some controls and make smaller the form and if user selects a checkbox to show these controls that exist inside a box and grow the form.

View 1 Replies View Related

Forms :: Linking Labels To Controls

May 17, 2014

I cannot link a label with a control. I don't know how it happens, or rather how I do it, but on various forms the label is not linked to the proper control. I try to do it by clicking on the warning popup on the right side and indicate I want to associate the label with the control, but sometimes it just doesn't work. That is, if I set the visibility of the control to True or False depending on the value of another control, the label still appears.

I've looked in the properties of each, but there doesn't seem to be anything there to indicate the link or association. Other than laboriously copying and pasting the label back on the form with the control highlighted, is there any way else to do this?

View 11 Replies View Related

Forms :: Referencing Controls On Subforms

Oct 23, 2014

In the attached picture has a representation of my setup.

My main form has a listbox search form (taken from this site). The search results populate data in subform1.

In the detail section of main form has subform1 with 3 cascading combo boxes. I have queries set up that run the cascading combo boxes.

In the detail of subform1, I have subform2 with a combo box.

Today I decided to merge my search form and the other forms so I wouldn't have two pages. Everything used to work with no errors - but I can't figure out how to reference everything properly now.

I've tried every combination from here to reference things properly. Somehow, I'm missing something.

View 12 Replies View Related







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