Search results

on opening the main form for the first time and clicking search the error "the expression you entered refers to an object that is closed or doesnt exist" I assume this is do to the cursor not being limited to one text box or intially clicked in one area?

first try with policynumber.setfocus will not work and says object required. tried adding screen.policynumber.setfocus and it gave me a compile error mehtod or data member not found am i just not referencing the text box correctly?

in one of my other posts I had another question and just curious if it is possible. I can set a field to a default of nothing or like my line of business field on the main form to a default of cnr. Now, is it possible to set the subform area to come up blank instead of displaying the last form...

my apologies. this is what im using Function FindRecord() On Error GoTo Err_cmdFindRecord_Click Screen.PreviousControl.SetFocus DoCmd.RunCommand acCmdFind Exit_cmdFindRecord_Click: Exit Function Err_cmdFindRecord_Click: MsgBox Err.Description Resume...

Assuming you ran a query to pull data from the tbl to create another form*subform) you should be able to use that subform within the main form without issue. Atleast that is what I do when i do overlays. I setup one main form and create a bunch of subforms based on a bunch of queries and i...

also, is there a way to hard code the search button to one field. Say my policy number field? That way the user wont have to worry about where the cursor is located for search purposes

thanks, i assumed it was there i just did not know if there would be an issue with the order in which the code was provided this is what i did and it works Private Sub Form_Load() Me.frmCNRCancellation.Visible = True DoCmd.GoToRecord , , acNewRec End Sub now one more quick question. If...

i guess i did the data entry choice to force it to a new record each time. I honestly had no clue about the limitations it enforces. In regards to your code and considering im still quite new to vba. Does it matter where i place that code in the list of items? In otherwords i assume there...

The issue i have is upon opening my form the command buttons will not locate previous records however once you input a new record it will allow the function to search and the previous and next record buttons to work(but they still dont show previous records). Once the form is closed and...

to give you an idea of what they were initially using i have attached an excel spreadsheet. there are 20 versions of this form each with slight differences. I am not sure if i normalized the db in the correct way as it seems i drove the db off of the form.. hope this gives some insight as to...

I assumed i would need referential integrity on the join for the tables so that if an item had to be amended or say the comments field was amended that there would not be an issue. Although no data will ever be deleted from these tables. The parent table is the header table. Also at the top...

i also tried changing the direction or way you draw the connection from the child to the parent table with no luck there either.

This is one of my bigger dbs that i have created. Most contain one to two tables without much issue as the form has always referenced one table. I think my issue arises from the table being empty and trying to save so after trying to force a null value the error still pops up. Is there a...