Recent content by flushfire

Thanks for the suggestions! I never thought about using a listbox. I'll see if I can manage to use it to replace the solution I have right now. I made a little workaround, I made separate tables for each preset, then I append that table after applying checking with the same queries I use to...

I have this form here: What I want to do is give the end-user the option to input a preset of subjects that is also customizable. One way I know of doing it would be using a table then appending it to the table which the subform Subjects is based off of, however i think that would skip the...

Thanks for the solution, I'll try that. Edit: I still have the problem of how to check if the student has already passed the prerequisites before showing the available subjects. Here's a shot of the contents of the Subject table: I need to filter the subjects available to each students based...

Ive read the sticky about using tables to exclude data, unfortunately I can't figure out exactly what to do to get the results I want even after reading it. Anyway here's my problem - I want a field in my Enrollment table to lookup data from my Subjects table but exclude data that does not meet...

thanks, will read up on that. :)

I need a field that auto increments. My problems are it also needs to have a prefix of "541-", and there is already an existing record (on paper) so i cannot start from 0. I have tried using format and max (field) + 1 but I can't get those to work properly. Any help?

This turned out to be the best solution. I did not know that when using datasheets there can be only one current record. Anyway, thank you for this tip. :D

eh? that was the question in the first place, how do i add the load number? I don't know how to refer to the selected records without having the user check some boxes or type in filters. What i want is for them to click/select the records in datasheet view and then press a button and then that...

I have a form with a field load number. I have a subform in datasheet view called orders, and another subform based on a query where it displays the orders tagged with the load number in my main form. What I want to be able to do is for the user to be able to select orders from my first subform...