- This topic has 1 reply, 2 voices, and was last updated 12 years, 1 month ago by .
Viewing 2 posts - 1 through 2 (of 2 total)
Viewing 2 posts - 1 through 2 (of 2 total)
- You must be logged in to reply to this topic.
Integrated Application Platform
Integrated Application Platform › Forums › General › Access help
Hello. Its me again. I have a small prob with my assess and browse. Here is my code:
#(Access ssb_load
startNew: True
nextNum: #(field: load_num,
table: ssb_nextnum, table_field: nextnum)
title: ‘Wagram Paper Stock SSB Load Database’
(Vert
(Horz ld_loc (Skip 40) date_proc (Skip 40) load_num)
(Horz ld_al_wt (Skip 40) ld_drink_wt (Skip 40) ld_pill_wt)
(Horz ld_ow_wt (Skip 40) ld_hanger_wt (Skip 38) ld_film_wt)
(Horz ld_book_wt (Skip 40) ld_trash_wt (Skip 40) ld_cb_wt)
Skip
(Horz ld_tot_wt (Skip 40) num_bales)
Skip
(Browse “ssb_ld_bales”
stickyFields: #(load_num)
columns: (load_num, store_num, num_bales)
linkField: load_num_new
name: “ssb_load”
)
)
)
I want to carry the load_num gotten from the nextNum down to use it as a sticky value in each browse line. Im sure that its something very simple but I cant figure it out.
Thanks
Benny
If you specify the name and linkField options of Browse properly I think load_num will populate automatically on the browse lines for you.
The BrowseControl ‘name’ option should be the field name you want from the Access record. This is load_num in your case.
The BrowseControl ‘linkField’ option should be the field in the Browse query that corresponds with the field you specified as the name option. In your case I think this is load_num for the Browse query as well. You have specified load_num_new which is incorrect based on the columns you are displaying in the Browse.