Access help

[Anonymous]

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

[j_ferguson]

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.

[Author]

Posts