I have a small network sharing a SBC DSL connection using a speedstream 5100b modem and a USR 8003 Broadband Router. PPPoE is on the modem and the router does DHCP on the Lan side. There are two win98se machines and two winxp pro machines on the network. The 98 boxes work fine with no problems...
Well I'm not currently getting $59 in Fee with the code provided by Robert and Thorn I get nothing. I was getting the $59 when I had the code in the AfterUpdate of the Fee txtbox. I since moved the new code to the Form AfterUpdate and now I'm getting nothing.
The two ComboBoxes are each one...
Yes "Fee" is an unbound textbox in the Form and it is labeled "Fee" Under the DATA Tab Enabled = Yes; Locked=No; Filter Lookup=Database Default.
Thanks for your help Robert.
Well guys, I've tried both your versions and it doesn't work. Here's what I used:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Select Case Me.Housing
Case "AF_Smith", "Windham", "Alexander"
If Me.Plan = "All" Then
Me.Fee = 79...
Well I don't know where the $249 came from but if you want a room for that rate we can accomodate. The possible prices should be $49, $59, $79, and $99.
Thanks for your help!
Well, I've been busy with other things for a while and just got back around to this, Below is the code I came up with, but it desn't work. I get $59 not matter what combination I choose.
Private Sub Fee_AfterUpdate()
If ((Housing = AF_Smith) Or (Housing = Alexander) Or (Housing = Windham)) Then...
Let me be more specific, because I'm still lost.
Combobox "Housing" list comes from Table "Housing" which has the following choices - House1, House2, House3, House4, and House5. Combobox "Plan" list comes from the Query "Housing" which has the following...
I have a form with two combo boxes "Housing" and "Plan". There is a text box called "Fee". There are six housing choices and four plan choices. There are four possible fees associated with all the combinations of "Housing" and "Plans".
How do I...
I have a form called "people" to enter new records that contains twenty or so fields. The form has a button for cmdPrint which prints another report called "badge" that is comprised of seven of the fields from the form "people". This function works when I retrieve a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.