finding vb coded method

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

have just looked at a Form that at first glance seemed very straight forward.

but then I discovered that the Form was unbound, and all the fields too.
This form has a "Submit" button which has for the OnClick Event the vb code:
Call 'UpdateData'

So I looked over in the Modules area and while there were a couple there - -
I do not find a Module named UpdateDate....so now am wondering where else
this code would be located....haven't seen it in the code for the form.

thanks for advice in advance,
 
NetworkTrade said:
have just looked at a Form that at first glance seemed very straight forward.

but then I discovered that the Form was unbound, and all the fields too.
This form has a "Submit" button which has for the OnClick Event the vb code:
Call 'UpdateData'

So I looked over in the Modules area and while there were a couple there - -
I do not find a Module named UpdateDate....so now am wondering where else
this code would be located....haven't seen it in the code for the form.

thanks for advice in advance,


Look for a procedure (Sub or Function), not a module, with the name
UpdateData. Open any module in design mode, and then use Find to
search for the procedure, and make sure the Find range is "Current
Project".

HTH
Matthias Kläy
 
The most simple method to find the function would be to click on the funciton
name and right click and select the "Definition" option. This will take you
to the location were the function exists.
 
thanks both....the suggestion to rightclick for definition was particularly
helpful and took me right to the code.

I guess the writer was a vb jockey and not so familiar with Access. He/She
did an elaborate coding method with sql insert methods that essentially could
have been simply accomplished by just having the form bound to the table.

thanks
 
Not knowing anything about the application your are working on, I would just
say that there are occasions where unbound is quite handy. However, I agree
with you that in most cases it is much more advantageous to just use bound
controls to most likely a query to pull the data.

Just as a note, I will many times use VBA to modify the sql statement of the
query that provides the data for the forms.

Glad to help.

Mr B
 
Back
Top