Opening specific invoice from command button

[tjuk123]

Firstly, i hope this is posted in the right place.



I have very little access experience and so have been looking on the internet how to modify an existing database template to meet my needs.

I am trying to create a command button that sits on the order details page and that will open up a report i have created called 'picklist' which is basically the same as an invoice but with some different product information listed on it.

I want the command button to open up the picklist that corresponds to the order that i am on e.g picklist #2 for invoice#2

I have 2 issues/questions:

1) I have seen this code on the internet -

DoCmd.OpenForm "SecondFormName", , , "FieldName = #" & Me.ControlName & "#"

Would this work for me if i was to modidy it to:

DoCmd.OpenForm "PickList", , , "InvoiceID = #" & Me.[txtID] & "#"

2) Where do i input this code? If i click on the 'onclick' in the properties form im presented with this page (attachment):

Hope this makes sense.

Thanks

[ItsMe]

If InvoiceID is type number then

DoCmd.OpenForm "PickList", , , "InvoiceID = " & Me.[txtID]

You could place it behind a command button in its click event.

While in Design View of your form, highlight your Command Button. Take a look at the Event tab in the property sheet. Click the ellipses (...) next to the On Click event and select Code Builder.

[tjuk123]

Hi itsme

Where do i select code builder from? It just opens up straight into the page that is in the pic above.

[tjuk123]

I think ive worked out why - is it because its a web database

[ItsMe]

Correct, web forms do not support Visual Basic code. You will need to create a Web Macros to automate your web forms. Also, I believe Web Forms have been deprecated starting with Access 2013. I believe Access 2013 requires a Share Point site/list in order to build a Web App. I tried to find the list of deprecated items in Access 2013 but cannot.

Unfortunately, I have little to no experience with Macros and no experience with Web Forms.

[June7]

The action you want to select in the macro is OpenForm. Then fill in the boxes in the macro

[ssanfu]

<snip>I tried to find the list of deprecated items in Access 2013 but cannot.

@ItsMe, I did find these sites:


Discontinued features and modified functionality in Access 2013
http://office.microsoft.com/en-us/ac...102749226.aspx

Differences Between Access Versions 2003 Thru 2013, Any Version
http://www.utteraccess.com/forum/Dif...-t2009685.html

Changes in Office 2013
http://technet.microsoft.com/en-us/l...ice.15%29.aspx