Search results

Trying to build a field default value using data from a field in a different table. The deafult value contains multiple elements text ("ASFL"); then two-digit, fiscal year (12); then three digit julian date (123). I tried to use varying themes on the following to no avail: = Display Text...

Trying to build a field default value using data from a field in a different table. The deafult value contains multiple elements text ("ASFL"); then two-digit, fiscal year (12); then three digit julian date (123). I tried to use varying themes on the following to no avail: = Display Text...

Sorry for the confusion; I really need help. I'll try to clarify. My sub form, DODAAC_subform, is set to hide/show based on whether my user enters data that is found in my DODAAC table. What happens now: if user enters data not found in the DODAAC table, my subform appears; however, it...

Vila, thanks for bailing out the newb! Worked like a charm. Paul.:D

I formatted my subform; yet, that formatting is missing when the subfrom appears on the main form. The subform appears in a list instead of the formatted version. Any ideas? Thanks in advance. Paul

Bob, Thanks for the idea. I moved the SetFocus and Command to BeforeUpdate: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.City1) Then Me.DODAAC_subform.SetFocus DoCmd.GoToRecord acDataForm, "DODAAC_subform", acNewRec End If End Sub Debugging wouldn't allow the SetFocus...

Main Form is called frm_pickups tied to table Pickups Sub Form is called DODAAC_subform tied to table DODAAC DODAAC_subform is hidden until the user enters data in the control on the main form which doesn't exist in the table DODAAC. Private Sub DODAACCS_LostFocus() If IsNull(Me.City1) Then...

Thanks mistera, your suggestion made the subform appear. Unfortunately, I only want it to appear if the user enters data in the fields DODAAC1, DODAAC2, DODAAC3 or DODAAC4 that doesn't already exist in the DODAAC table. Also, I'd like to hide the subform once the user enters the missing data...

I have a main form called frm_Pickups tied to a table called Pickups and a subform called DODAAC subform tied to a table named DODAAC. On frm-Pickups, I have four fields named DODAAC1, DODAAC2, DODAAC3, and DODAAC4. What I would like is to have the DODAAC subform appear whenever the user...

Hi rammudali, Good suggestion; but, I think I'm still missing something. Rather than using dlookup on the 4 control fields, I also have 4 unbound, lookup fields called City1, City 2, etc... Could I check to if they are blank with Select Case Case Me.City1 = Null...

Thanks for the reply Sue. Unfortunately, that code only works with a checkbox on the main form. I need code to make my subform appear when a user enters a 6 digit code in a field on the main form that doesn't exist in an associated secondary table (tied to the subform--not the main). I...

Sorry; forgot to add I'm using Access 2010.

Still trying to wrap my mind around the coding and was hoping you could help... The parent form (Main) is tied to a table named Main; Subform is tied to a table named DODAAC. On the parent form are 4 fields I want to use to make the subform appear any time the user enters data which isn't in...

Thanks Ghudson. Your advice: "You need to rename your objects (labels, text boxes, etc) with something meaningfull and give them a prefix that identifies what it is. text box = txtTextBoxName, label = lblLabelName, etc..." was spot on! While I copied DODAAC2, 3, and 4, I forgot to change...

Thanks for the quick response, Dave! I used the code below: Private Sub StopSplit_Change() Select Case StopSplit Case "2" Me.Label48.Visible = True Me.DODAAC2.Visible = True Me.Label45.Visible = True Me.Text44.Visible = True Me.Label47.Visible = True Me.Text46.Visible = True Case "3"...

2010 Access VBA newb on a network. I have a couple of fields that I want hidden until user checks the controlbox. Found a soultion that requires a userform. Trying to insert a userform in VBA; however, it's not available on the insert menu. Is it possible our network admin has blocked...