Search results

Thanks that worked a treat! But now, I want to be able to edit the text that autofills in, if I change the text and leave the record it reverts to the text that is in the code. Is there a way to change the text?

Hope this is the right group, I have a continuous form that has a 3 column drop down list box, on selecting a value from the drop down list it fills in two text boxes. This all works, my problem is: When I select a value from the list it fills in one of the text boxes, when this text box is a...

dataentry property is set to no, If I create another form like the previous form it shows the fields, like it should, the other form was working fine, I would rather get that one working again rather than re-coding the new form. The query is just based on the table

none of that was set. I hope some one will be able to help, Cheers

Yeah its deffinitely the right form, its the one I was working on before I did, whatever it was I did. In design view all the fields, subforms, command buttons and drop down lists are there, This form is like the Main form which data is to be entered into.

I had a form based on query, to enter data in, it was displaying everything fine, I have since done something, which I don't know what, and now everytime I open the form it opens blank with no fields at all. I have checked filters and none are set. If I enter data directly in to the table the...

I hope I'm not annoying you too much! But...the code I have been using is an IF statement IF me.strLandTrust = "Specific Land Trust" THEN textbox4 = "specific string of text , and if I have it in both the after_update and the form_current it wont let me manually change the text in textbox4 as...

If I have the code in the AfterUpdate of textbox2, but it doesn't fill in textbox4. If I put the code also in Form_Current, the text goes into textbox4. but as you know when I change something and then go to the record it changes back because of the form_current.

My form is an application form to enter in to communities, so I have a drop down box to select the community(textbox1) to enter, this then autopopulates the LandTrust (textbox2) field and the Region (textbox3) field, that the community resides in. I then have another textbox (textbox4) which...

when I take the code out of Form_Current, nothing changes with textbox3, what ever is in textbox3 stays there, if I start a new record, nothing auto fills into it.

The code is on textbox2 After Update and on Form Current the code is along these lines: 'Select Case Me.TextBox2 'Case "Specific value" 'Forms!frmTransitPermitApplication!textbox3.Value = "Specific string of text." this works but when I have to change the "Specific string of text", leaving...

The control source for each text box is set to its corresponding field in the table eg Land Trust is set to strLandTrust, Region strRegion and Roads to use strRoadsToUse. Land Trust and Region are autofilled with the combo box strCommunity. my problem is when Land Trust gets a specific value...

I have a lookup combo box which fills in text box1 and text box2, I have then set text box1 for if it recieves a specific value, it will fill in another text box(text box3). This all works, but occasionally, text box3 will require a different value, if I type in another value, going from one...

OK, I've restructured, I set up a new table, and a command button on the main form which opens the form to add more people. How do I go about, extracting those names to fill in a form for their signatures, like I was saying before, for one applicant there could from 0 to alot accompanying them.

If I have a memo field, which lists people's names, is there anyway I can extract, each persons name to fill in other fields. I'm designing a database as an application form, which has the main applicant, and "other people accompanying", this can have from 0 other people up to a coach load of...

I keep getting an error message on a form of mine, when I click on either of the command buttons that I set up, which I created from the wizard, one to print and one to close the form. The attachment has the error message. (in word2000 format)

I'll try and explain better, I have three columns in a list box, one for Community to visit, Land Trust, and Region. On the main form it doesn't need Land Trust or Region, but, I need that information filled into the table. Is there a way to get these filled in without having the fields on the...

And how about with another list box I have, it uses a lookup table, with three fields, what do I do to get a selection from the list box, to fill in fields in a table, but the fields aren't on the form?

Thanks for that, it worked like a charm! With this though, I have a lot of fields that I want to be able to hide. Can I group fields and then just hide the group?

I have a form which has a list box, I want to be able to select one of it's options, and on it's selection, have some fields on the form become visible. How would I go about doing this?